Monitoring wait stats
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-02-23
163 reads
SQL In The Wild
Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
464 reads
Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
98 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,920 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
146 reads
On the addition of useless where clauses
I remember a forum thread from a while back. The question was on how to get rid of the index...
2016-02-10 (first published: 2016-02-02)
2,407 reads
Does an index scan always read the entire index?
No.
That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a...
2016-01-26
487 reads
Stop using Task Manager to check SQL’s memory usage!
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why...
2016-01-19
2,000 reads
Natively compiled user-defined functions
One new thing that SQL Server 2016 has added is the ability to natively compile user-defined functions. Previously, native compilation,...
2016-01-19 (first published: 2016-01-12)
3,859 reads
Book Review 2015
It’s been a few years since I wrote a review of books I’ve read, so this isn’t going to list...
2016-01-15 (first published: 2016-01-05)
1,712 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers