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
854 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,604 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,387 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,942 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,531 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,244 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,200 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,961 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,145 reads
Blogs
Free SQL Practice: 9 Killer Resources to Boost Your Query Skills
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
DevOps Devour Hour Slides
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
Advice I Like: Take Two Trips
By Steve Jones
If you have any doubt about being able to carry a load in one...
Forums
Is there an ISERROR equivalent in SS?
Hi everyone I have a SP that just failed. Format of SP is: Select...
Analyzing Tempdb Spills and Usage Across Recursive Queries
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Creating a new API in Data API Builder
Comments posted to this topic are about the item Creating a new API in...
Question of the Day
Creating a new API in Data API Builder
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers