SQL Live 360 Competition Winner and Answers!
About a month ago I started a competition (hosted by the event organizers) to give away a free pass to...
2013-10-16
471 reads
Blog Posts
SQL Server 2014 CTP2 …ready to download
Announced and available for download the SQL Server 2014 CTP2:
Release Note:
http://msdn.microsoft.com/en-us/library/dn169381%28v=sql.15%29.aspx?lc=1033
Download Location:
http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx
…and something that is very welcome for the community...
2013-10-16
1,426 reads
SQL Server 2014 CTP2 Available to Download
At the PASS Summit keynote today Quentin Clark announced that SQL Server CTP2 (which is public and the last public review) and is available right now to download here....
2013-10-16
16 reads
SQL Server MVP for the 2nd time in row!
I’m honored to be recognized as SQL Server MVP for the 2nd time in row and thank you Microsoft to...
2013-10-16
1,040 reads
Summit 2013 – Part the First
While not technically the first day of Summit since the official start is yet to come, here are my thoughts...
2013-10-16
657 reads
Summit 2013 – Part the First
While not technically the first day of Summit since the official start is yet to come, here are my thoughts on Sunday and Monday of PASS Summit 2013. For...
2013-10-16
4 reads
TempDB Contention 2.1.%
Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of 2.1.103...
2013-10-16
744 reads
Attending the SQL PASS Summit?
Are you attending the SQL PASS Summit conference in Charlotte, NC this week? If so, let’s meet up! If not,...
2013-10-15
906 reads
DMV-15 : Pending I/O requests……..sys.dm_io_pending_io_requests
sys.dm_io_pending_io_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188762.aspx
Returns a row for each pending I/O request in SQL...
2013-10-15
1,393 reads
October 2013 – Monthly SQL Server Checklist
It’s not the first Monday of October, instead it’s the second Tuesday (oops, had Wednesday in here originally). As we...
2013-10-15
623 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