Paying Attention to Estimates
Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
SQL SERVER – A Timeout (30000 milliseconds) was Reached While Waiting for a Transaction Response from the MSSQLSERVER
Recently I was contacted by a client who reported very strange error in the SQL Server machine. These consulting engagements sometimes get the best out of you when it comes to troubleshooting. They reported that they see timeout error. My question was …
How to Drop Clustered Index on Primary Key Column? – Interview Question of the Week #084
Question: How to drop clustered index, which is created on primary key? Answer: If you thought the answer as simple as following script, you are wrong. DROP INDEX PK_Table1_Col1 ON Table1 GO When you run above script on Table1 where PK_Table1_Col1 is c …
[Video] Office Hours 2016/08/10 (With Transcriptions)
This week, Brent, Richie, Erik, and Tara get together in Round Rock, TX, for Dell DBA Days, to talk through your SQL questions and answers. They discuss what they are working on at Dell during the event, as well as Windows Kerberos and NTLM Authenticat …
SQL SERVER – Installation Fails With Error – A Constraint Violation Occurred
In my recent past, I have helped around 10 customers who have had similar problems while installing SQL Server Cluster on windows. So I thought it would be a nice idea to pen it down as a blog post so that it can help others in future. In this blog pos …
Dell DBA Days: What kind of hardware can you buy for one core’s worth of Enterprise Edition?
Dell R730 Microsoft charges $14,256 for a 2-core pack of SQL Server 2016 Enterprise Edition. So how much hardware can we get for $7,128? I started with one of the more common 2-socket server models, a Dell PowerEdge R730, and then optioned it with: Cha …
Scalable No-Guesswork Deployments with the HPE Superdome X and SQL Server 2016 Reference Architecture
There are several ways you can go about adding new servers into your organization’s IT infrastructure. You can do the research yourself and attempt to put together your own custom configurations, or you can use a reference architecture. read more
Call for Articles
SQLServerCentral is looking for articles on a few topics. Read more to find out how to submit a draft.
Biml Academy 2 – Importing, Staging, and Loading Data
Next week are 5 more lessons on working iwth Bilm. Each day, Aug 15-19, at 1:00pm EDT.
SQL Server Stored Procedure to Compress Non Partitioned Tables
My SQL Server database has some very big tables that can be compressed. The tables are simple, non-partitioned tables and I want a quick tool to compress them. I
Writing Better T-SQL: Top-Down Design May Not be the Best Choice
One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.
Database on a diet–final section (part 4)
Hi Folks, I’ve been writing articles for SQL Server Magazine as part of my Data Tales series. Over the last couple of months, I’ve been writing a min-series about a database on a diet. Earlier parts described the need for size reduction, ho …
SQL SERVER – Creating a Copy of Database in Azure SQL DB
Recently I was about to undertake an interesting assignment for one of my clients who pinged me for Performance Tuning exercise. Since this is something I have been doing full time in the past couple of months, I got into the call immediately. Lesser d …
Questions About Azure SQL Database You Were Too Shy to Ask
The Questions How do I create an Azure SQL Server instance? How would I go about creating a SQL Database? How to add entries to the SQL Database firewall? How can I change the database Service Tier to either scale-up or down? How can I do a point-in-ti …
Bad Idea Jeans: Dynamically Generating Ugly Queries and Task Manager Graffiti
Say you’re at Dell DBA Days, and you want to build a really ugly query, fast. You want to generate a StackOverflow database query that will take a long time to compile, and maybe demand a huge amount of memory to run, but not actually take any ti …