SQL Server Bugs That Might Bite You
I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials...
2014-12-10
500 reads
The Truth About Index Fragmentation
In just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download...
2014-11-20
457 reads
Show Only Specific Databases
One of our customers is implementing a very large consolidation project in which they enable users to create their own...
2013-01-08
307 reads
SELECT Top 4 Bugs FROM DBAs IN SQL Server
I gathered the 4 most common bugs I find DBA are using in their code. Feel free to send me...
2012-11-11
462 reads
Parallel Processing For Pros
Hi,
Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...
2012-06-05
317 reads
Update Statistics and the new TraceFlag 2371
What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?
The Statistics life cycle
As a regular...
2012-01-18
369 reads
Pro and Cons of Parameter Sniffing
Look at the following 3 scripts:
-- 1. Hardcoded
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime < '19900101'
-- 2. Variable
DECLARE @FilterDate DATETIME = '19900101'
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime...
2012-01-02
441 reads
2011-09-03
345 reads
Answer to the Quiz
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-28
324 reads
Answer to the Quiz
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-27
440 reads
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Alamat kontak resmi BCA KCP Taman Melati Telp:0817866887
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
Alamat kontak resmi BCA KCU DEPOK Telp:0817866887
WhatsApp:0817866887 Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok, Jawa Barat 16423
Alamat kontak resmi BCA KCU PURWAKARTA Telp:0817866887
WhatsApp:0817866887 Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta, Kabupaten...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers