Filetable–Nesting folders and files
In previous posts I showed how to create a folder in a Filetable and also how to the create (and...
2014-05-12
1,094 reads
Writing Another Question of the Day
The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily,...
2014-05-12
360 reads
Last Weeks Top “Reading” Links #83
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-05-12
879 reads
Notes From SQLSaturday #298
The trip didn’t start smoothly for this one. Wed night I was really sick with some kind of stomach flu....
2014-05-12
433 reads
Making a Difference – #SQLFamily
When I started with the SQL Community I was first encourage to start blogging which I started in Sept of...
2014-05-12
1,213 reads
SQL Saturday Houston
I spoke for my first time at a SQL Saturday in Houston this past week. I had a lot of...
2014-05-12
735 reads
How to Fix that Never-Ending Join Dragging Down the Whole DB Server Instance – Pre-Populate the Largest Bugger in Temp with Indexes
Now that it has been a
good five years I have been blogging away here and on SSC, the editors recently thanked
us...
2014-05-12
1,064 reads
Boost the performance of the VMware vSphere Web Client
Ever since it was released, the vSphere Web Client is not the most responsive of web GUIs. After some digging,...
2014-05-12
438 reads
Add Node to Windows Server 2008 Cluster
Steps : Add Node to Windows Server 2008 Cluster
1) Open Cluster Administration wizard > Right click on Windows Cluster & select Add Node
2)...
2014-05-12
1,901 reads
Presentation slides for Houston SQLSaturday
Thanks to everyone who attended my two sessions at SQLSaturday in Houston (more info). Here are the abstracts and PowerPoint links:
Best...
2014-05-12
924 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers