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,453 reads
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,453 reads
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,155 reads
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,283 reads
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,094 reads
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,519 reads
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,129 reads
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,188 reads
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,953 reads
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,138 reads
Yes after its initial release and pull out Microsoft has again made the Service pack 1 for SQL SERVER 2014...
2015-05-20
452 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Hi All, We are seeing MSDTC transactions are blocking other sessions within sql server....
Hi All, Today, I came across a blocking issue from the application. A very...
Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers