SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
535 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
203 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
907 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
479 reads
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-03-02 (first published: 2016-02-23)
2,258 reads
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
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
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
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
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