SQL Server’s statistics
Again another interesting article from RED GATE …
SQL Server’s statistics provide the query optimizer with the information it needs to...
2015-09-14
851 reads
Prakash K
- Website: http://sqlserversdba.wordpress.com
Live Query Statistics
The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option...
2015-08-27 (first published: 2015-08-19)
2,561 reads
How to find CPU intensive queries ?
HI all
Today received the mail from RED-GATE team on this topic “How to find CPU intensive queries” . It is an...
2015-08-24 (first published: 2015-08-17)
10,365 reads
List Out All the SQL servers In domain
HI ALL
In One Of the Group the question was asked that How to list all the Servers in which SQL...
2015-07-30
17,758 reads
SQL server 2016 CTP 2.2
Microsoft has announced that The SQL Server 2016 Upgrade Advisor Preview and SQL Server 2016 Community Technology Preview (CTP) 2.2 are...
2015-07-23
1,095 reads
COLUMNSTORE INDEX… DEMO
COLUMNSTORE INDEX
How data is stored in traditional way
For physical storage of a table, its rows are divided into a...
2015-07-11
2,527 reads
How to Grant limited permissions to create views in another schema?
How to Grant limited permissions to create views in another schema?
In SQL Server 2005 and 2008R2 you can grant permissions...
2015-07-08 (first published: 2015-07-01)
3,236 reads
SQL SERVER REPORTING SERVICE MIGRATION
Last week as part of job I had to migrate the Databases and Reporting Service of SQL server 2005 To...
2015-06-22 (first published: 2015-06-11)
3,199 reads
SQL Server 2016 features to look for -2
In Previous post we have seen the new features of SQL server 2016 in short and had a brief discussion...
2015-06-11 (first published: 2015-06-08)
4,959 reads
SQL Server 2016 features to look for -1
At this year’s inaugural Ignite Conference in held in Chicago Microsoft announced that the next release of SQL Server, previously...
2015-06-03
1,144 reads
Blogs
BK’s Bookshelf: Never Split the Difference
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report...
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
Forums
The Oldest Article
Comments posted to this topic are about the item The Oldest Article
Happy New Year 2025
Comments posted to this topic are about the item Happy New Year 2025
Using a RETURN
How does this capture multiple values from a cursor, and put them into an...
Question of the Day
The Oldest Article
What's the oldest article on SQL Server Central (take a guess)?
See possible answers