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
861 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,703 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,411 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
18,093 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,100 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,541 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,260 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,217 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,965 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,151 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers