Microsoft releases SQL Server 2014 CTP2
Microsoft has released SQL Server 2014 CTP2 (download):
What’s new in SQL Server 2014 CTP2?
New Mission Critical Capabilities and Enhancements
Enhanced In-Memory...
2013-10-24
1,828 reads
Blog Posts
PowerShell – Disk Space GUI Tool
PowerShell – Disk Space GUI Tool - Sharing a useful PowerShell GUI script to check disk drive usage along with a graph.
Copy and...
2013-10-24 (first published: 2013-10-14)
4,566 reads
SQL #51 – Timeout when updating a big table
A co-worker recently asked me why she would get timeout when updating a column in a big table. This column...
2013-10-24
16,757 reads
SQL #52 – set statistics xml on
When tuning SQL queries, I find that I use the following three SET options quite often.
set showplan_xml on
When showplan_xml...
2013-10-24
1,875 reads
SQL Query Formatting – Putting Lipstick On A Pig
“Psssst….”
“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this...
2013-10-24
921 reads
SQL Server Inetrview FAQ 3
1. How to find the maximum no of connection allowed in SQL Server?
Select@@MAX_Connections
2. How to select top 2 rows without...
2013-10-24
1,096 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.4: Node Navigation
By Steve Bolton
…………The pinnacle of difficulty in this series of amateur self-tutorials on SQL Server Data Mining (SSDM) was surmounted...
2013-10-23 (first published: 2013-10-15)
2,125 reads
Get list of dates using recursive Common Table Expression (CTE)
Many times we need a list of consecutive dates or time at runtime mainly for a recursive ETL process. This...
2013-10-23
1,123 reads
Memory Optimization Advisor – SQL Server 2014 CTP2
SQLServer 2014 CTP2 came with an inbuilt tool called Memory Optimization Advisor which will help you in migrating your normal...
2013-10-23
1,222 reads
PASS Summit 2014-Networking Dinner & After Hours
Yes, it is early, but I’ve set up the invitation for the fifth annual Monday Night Networking Dinner at the...
2013-10-23
749 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
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
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
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