SQL Server – Script to Configure TempDB Files per Number of Logical Processors
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,230 reads
SqlServerZest.com - SQL in simple style
SQL Server – How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell
Often times it is required to find out the SQL name from the host names in a clustered environment so you...
2014-04-14
1,165 reads
SQL Server – Using Tools to Analyze Query Performance
Here is the session I gave for the techies at Microsoft about in-built tools available in SQL Server to analyze...
2014-02-11
954 reads
SQL Server – Deploying Multiple SSIS Packages into SQL Server Using Command Prompt Utility – DTUTIL
Though there are several ways for importing SSIS packages into SQL Server either by creating a stored procedure or using...
2013-11-04
758 reads
SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data
Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard...
2013-10-14
1,126 reads
SQL Server – Restoring a TDE Encrypted Database to a Different Server
In this article I will show you how to restore a database that is encrypted with Transparent Data Encryption (TDE)...
2013-10-03
977 reads
SQL Server –Encrypting and Securing Native Backups Using Transparent Data Encryption (TDE)
Being part of the database engineering team, we were given a task to setup disaster recovery program for some of...
2013-10-03
749 reads
SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,472 reads
SQL Server – How to Add More Than One Column as a Primary Key
Sometimes you might want to add more than one column as primary key. For example, if you have three columns...
2013-09-17
591 reads
SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time
Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...
2013-09-16
483 reads
Blogs
When It’s Still Viable
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
T-SQL Tuesday #179: The Detective’s Toolkit
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Forums
Starting to Estimate Disk Storage for Memory-Optimized Tables
Comments posted to this topic are about the item Starting to Estimate Disk Storage...
Keep. It. Simple.
Comments posted to this topic are about the item Keep. It. Simple.
case statement with and like operators
Hello, I'm trying to remove results from this sql statement where the custid like...
Question of the Day
Starting to Estimate Disk Storage for Memory-Optimized Tables
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers