Sites anglophones

Paying Attention to Estimates

Publié le 15 août 2016 sur

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

Publié le 15 août 2016 sur journey to sqlauthority

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

Publié le 14 août 2016 sur journey to sqlauthority

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)

Publié le 13 août 2016 sur

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

Publié le 13 août 2016 sur journey to sqlauthority

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?

Publié le 12 août 2016 sur

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

Publié le 12 août 2016 sur

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

Publié le 12 août 2016 sur

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

Publié le 12 août 2016 sur

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

Publié le 12 août 2016 sur

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

Publié le 12 août 2016 sur

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)

Publié le 12 août 2016 sur

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

Publié le 12 août 2016 sur journey to sqlauthority

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

Publié le 11 août 2016 sur

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

Publié le 11 août 2016 sur

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 …

Pages :