SQLServerCentral.com Community Update for June 17, 2024

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

A Lack of Memory Grant Feedback Persistence

The Voice of the DBA

Five Years and Counting

I almost called this "chasing a new laptop" since that's what I'm doing, but I decided to add the date because the current laptop I've using was built in March 2019 and got to me in May 2019. I've had an HP Spectre x360, my second HP Spectre, and I've really enjoyed it. I'm also amazed it still runs. On the last few trips, the two rubber strips that run along the bottom (acting as feet) started to peel away. I've never seen that before and I tried to re-attach them a few times, but that didn't work well.

Not a big deal, and I can live with that, but then during my Australian tour, the laptop started pausing and freezing a few times. It might be that there is too much software on there and needs a pave-and-reinstall, but I decided to check the age on the machine. That was when I realized it was five years old. It's been a great machine, but I don't think I've ever had a work laptop last that long with daily use. Of course, there was about a year during the pandemic when it was rarely used, so maybe its life lengthened during COVID.

In any case, I started looking around for a new one. My initial glance at smaller laptops has me considering these: another HP Spectre x360, the ASUS 14, the Lenovo Thinkpad X1 Carbon, and the DELL XPS 14. That's the short list, since I really want a Windows PC that can run SQL Server and tools locally. I've had a Macbook before, and in the past I could run a VM with Windows tools. I can run SQL Server now, but not SSMS, and I like running SSMS.

I'm just starting to look at some reviews, and think about what I need. I've had a i7 CPU, 16GB RAM, and a 1TB SSD, which have served me well for the last 5 years. I don't think I need more, though 32GB is tempting for a memory upgrade. I don't do a lot of heavy development, so it's more about having the things I run be snappy in presentations with customers and at conferences.

What machines do you use and like? I've appreciated the durability of the last two HPs, so I'm leaning towards another. I do like the pointer on the Lenovo, so that's tempting. I'd like a touch screen as I use it regularly, though I don't need a folding 2-in-1 machine. A normal clamshell is fine.

If you have a recommendation, let me know. If you have a dream machine, make me drool over it.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

Featured Contents

Working with SQL Server in Visual Studio Code

Daniel Calbimonte from SQLServerCentral

Learn how you can work with SQL Server in VS Code.

The CHECK() Constraint

Additional Articles from SimpleTalk

One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that the tables, rows and columns can have constraints on them. This allows you to reduce the types of bad data that can be loaded into your tables.

From the SQL Server Central Blogs - Why the masters and what lies ahead

Diligentdba 46159 from Mala's Data Blog

I recently graduated with a Master’s in Strategic Communication from the University of Delaware. Attending the graduation ceremony with my sister made it a truly memorable experience. Here’s a...

From the SQL Server Central Blogs - Copilot Reminded Me How To Find a File Handle

Steve Jones - SSC Editor from The Voice of the DBA

Recently I was trying to delete a folder and kept getting the “something is using this, try again” dialog. It was annoying, but I couldn’t figure out what process...

Deciphering Data Architectures

Additional Articles from SQLServerCentral

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	A Lack of Memory Grant Feedback Persistence
SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)
Think you know the answer? Click here, and find out if you are right.

Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Sensitivity Ranks

I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?

ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price, dbo.sales.discount WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Financial', RANK = 'INTERNAL ONLY' );

Answer: No, because the RANK is incorrect

Explanation: The issue is that the RANK parameter must be one of these values, unquoted as they are considered keywords for this statement:

NONE
LOW
MEDIUM
HIGH
CRITICAL

Ref: ADD SENSITIVITY CLASSIFICATION - https://learn.microsoft.com/en-us/sql/t-sql/statements/add-sensitivity-classification-transact-sql?view=sql-server-ver16

Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2017 - Administration

large transaction log backups - Hi All. From last 4-5 days we are seeing log backup file sizes increased from 500 MB's to 100GB files. What does it indicate and what should we checking at? the queries which are running during those times? This is not just happening during weekends (index rebuilds ..) but during weekdays also its the same […]

Schema Execute not working on sproc - I am VERY confused. We are switching an application from using a SQL login to using a windows login that is part of a windows security group. So the group has db_datareader, db_datawriter, and execute on schema dbo. There are a couple of db_denydatawriters on other groups, but this proc is not writing to any […]

SQL Server 2016 - Administration

SQL Error Log - number of files - Hi All, I need some assistance in understanding why my SQL error logs are not being deleted. I initially thought, the Error Log configuration was incorrect, but upon checking, it is set to Maximum 16 files (see below) which is what I wanted. I also setup an "sp_cycle_Errorlog" which created a new file, but history […]

SQL 2012 - General

Replication help, please! - I cannot get a snapshot to generate for one of my five publications. The snapshot gets to 99% complete and then goes to status: "The process is running and is waiting for a response from the server." Eventually, it restarts from 0% again. I've been playing this game for hours, and now I don't know […]

SQL Server 2019 - Administration

Run SSIS package asynchronously from SQL Agent job step - I'd like to run an SSIS package asynchronously from a SQL Agent job step through the the [SSISDB].[catalog].[create_execution] and [SSISDB].[catalog].[start_execution] stored procedures. I need the target package to be run by a specific login, so that login has been set as the owner of the SQL Agent job. However, the job step returns the error: […]

SQL Server 2019 - Development

odbc and netsuite - hi i just got off the phone with netsuite and we discussed their invoice api. it occurred to me that if that api isnt already limited column wise in what it can return about invoices entered in the last couple of days, it probably will be in the future. in our happy path we scrape […]

Stored Procedure - Error not found when temp table is used in join - Dear all, what I learned is that Stored Procedures (SP) are not compiled before they are executed the first time, but a syntax check takes place when creating it. What I don't understand is, that e.g. a wrong table column in a join is not leading to an error message as soon as a temp […]

Index Scan instead of index seek - Hello guys, I have the following query: SELECT COUNT(*) FROM "dbo"."STXL" INNER JOIN "dbo"."STXL_RET" ON "STXL_RET"."MANDT" = "STXL"."MANDT" AND "STXL_RET"."RELID" = "STXL"."RELID" AND "STXL_RET"."TDOBJECT" = "STXL"."TDOBJECT" AND "STXL_RET"."TDNAME" = "STXL"."TDNAME" AND "STXL_RET"."TDID" = "STXL"."TDID" AND "STXL_RET"."SRTF2" = "STXL"."SRTF2" AND "STXL_RET"."SPRAS_ISO" = "STXL"."SPRAS_ISO" WHERE "STXL_RET".ProcessName = 'ISAM_EKKO_T1' AND "STXL_RET".BoName = 'MM_EKKO' And the following indexes: STXL_RET […]

SQL Azure - Administration

SQL DB migration - Hi I am New To Azure Sql. Can some one please share If we can migrate sql 2017 db with symmetric key and certificate in it on Prem to Azure SQL database? how to restore db from one azure sql database to another azure awl database? Thanks

Azure Data Factory

deploying datafactory using YAML script - Error - Hi All, First foray into deploying adf using YAML scripting from Azure Devops from a dev resource to a test resource group..am using boilerplate code YAML code cribbed from the internet. The artifacts have been created correctly so that bit works. Deployment the second half requires creating in my azure project settings a service connection […]

General

Flower Delivery Sunshine - Are you looking for flower delivery in Sunshine? The stunning bouquets and arrangements that are available from The Flower Shed are suitable for any occasion. These florists guarantee the delivery of fresh, high-quality flowers directly to your door, so you can send flowers to celebrate birthdays, anniversaries, or just to cheer someone up. With choices […]

SQL Server 2022 - Administration

Servers being moved go new location - new IP addresses. - Hi Our Physical servers are going to be moved to a new location and new IP addresses will need to be assigned to the SQL servers. We use High Availability so will the listener sub net and IP need to be changed? I cant think of any other pain points - am I missing something? […]

Contained Availability Groups - Failover Questions. - Hi I am considering creating Contained Availability Groups in my production environment. Thinking I need to drop disabled jobs that live on both servers first? I've searched and read allot of Contained Availability Groups articles but none of them that I can find describe the failover process once the Contained Availability Groups are setup. During […]

SQL Server 2022 - Development

Using USE does not set DB context - Hi Experts, I have a Sql file with a bunch of DDL statements (Create Tables/Views). I start with a DB then change DB context to another DB followed by 2nd set of DDLs. In Sql file, I have: DECLARE @DB1 NVARCHAR(MAX) = 'DevDB', @DB2 NVARCHAR(MAX) = 'TestDB', @ENV NVARCHAR(MAX) SELECT @ENV = 'USE ' + […]

blocking due to cuncurrency problem. - hi, CREATE TABLE [dbo].[bridge]( bridgeid [bigint] NOT NULL, [idpool] bigint NULL, status int null CONSTRAINT [PK_bridge] PRIMARY KEY CLUSTERED ( [bridgeid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] Go bridgeid is pk , and […]

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.