2016-11-29
1,146 reads
Ren
Index rename to standards
Rename indexes according to pattern:
IX_<TableName>_<Col1>_<Col2>..
or
AK_<TableName>_<Col1>_<Col2>..
2014-10-06 (first published: 2014-09-04)
1,045 reads
Duplicate Records using SQLCMD
We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table.
2009-04-06
9,788 reads
How SSIS and Other Tools Obtain Metadata
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
2008-11-03
9,258 reads
Blogs
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Webcast Tomorrow on SQL Server Disaster Recovery
By Brian Kelley
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...
SQL Server Quickie #48 – Azure SQL Managed Instance
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking...
Forums
Azure elastic job issue authenticating to Azure SQL database
Azure elastic agent jobs: I’m getting this error “The server principal “ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3” is not...
Converting job_id to join to another table.
I need help, please! I have a monitoring table that pulls in information about...
SSMS 20.2 on Windows11 not able to connect to SQL 2005 ??
We still have a couple of dino's. What should I check to re-enable access...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers