On table variable row estimations
At first glance, the question of how many rows are estimated from a table variable is easy. But, is it really that simple? Well, not really. To dig into...
2020-12-23 (first published: 2020-12-15)
275 reads
At first glance, the question of how many rows are estimated from a table variable is easy. But, is it really that simple? Well, not really. To dig into...
2020-12-23 (first published: 2020-12-15)
275 reads
It’s a few days into April, but not too late I hope to mention that Pluralsight is offering their entire library, free to new accounts, for the month of...
2020-04-16 (first published: 2020-04-07)
453 reads
Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.
2019-09-09 (first published: 2015-05-25)
539 reads
Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.
2018-12-13 (first published: 2015-02-02)
474 reads
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,331 reads
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....
2018-03-26 (first published: 2018-03-13)
3,344 reads
A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators.
The...
2018-02-22 (first published: 2018-02-13)
2,118 reads
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
16,264 reads
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
488 reads
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
151 reads
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Hello where can I find to apply latest CU thank you
for installation sql server standard edition for instance id should I put server name?...
Hi all! I want to create a stored procedure that returns a result based...