Introduction
A few days back, in my article entitled ‘Master Data Services 2014: Creating nightly load processes’, I discussed the setting...
2014-01-02
3,915 reads
It’s 2014 now. I hope you had fun in new year’s eve.
2013 was an amazing and intense year. To recap...
2014-01-02
791 reads
My next all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL Server DBAs” will be held on January 17th...
2014-01-02
881 reads
A quiet and rainy day here in Orlando today. Not my favorite weather, but good for thinking, mostly about what...
2014-01-02
321 reads
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million...
2014-01-01
404 reads
Question :-
How many non clustered indexes are possible in a table in SQL Server 2008R2
1) 1
2) 249
3) 999 (Correct answer)
4)...
2014-01-01
1,099 reads
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...
2014-01-01
601 reads
This is the eighth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-01
8 reads
This is the eighth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-01
743 reads
Today I'm honored to give the final prize in a month of free giveaways here, the book; Professional SQL Server 2012...
2014-01-01
331 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
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