When installing a SQL Server 2005 instance on your SQL 2000 machine, there are upgrade and compability issues such as linked servers, multi-server administration and log shipping.
2007-08-06
2,679 reads
This Function is written to split Multivalued Parameter passed by Reporting Services 2005.
2012-07-16 (first published: 2007-08-01)
2,803 reads
Managing a large number of servers can be quite the challenge for many DBAs and it seems to get worse each year as more servers are added without an increase in staffing. New author Mark Tierney brings us the first part of a series on the framework he's built to help manage his servers.
2007-08-01
4,266 reads
SQL Scripter is an open-source console tool for generating SQL Server DDL. Written in C# using .NET 2.0, SQL Scripter provides front-ends for MSBuild, NAnt and the Windows command line. Each front end supports syntax for specifying which types of database objects to script, including all objects of a type or directly named instances.SQL Scripter […]
2007-10-12 (first published: 2007-07-31)
6,282 reads
this a quick sproc I put together to do various collation checks. databases that have different collations from serverdatabases that have different collations of columns withindatabases that have column collations different from database collation
2007-11-06 (first published: 2007-07-27)
2,375 reads
It might not be useful now, but if you ever wanted to downsize the amount of data that you keep in your datawarehouse, good luck. This will help you do that. This job is set to shrink it down to 120 days, but you can adjust it as you like. Runs again in 5 day […]
2007-10-16 (first published: 2007-07-26)
549 reads
I wrote this script because our MOM Datawarehousing got so damn behind.Every time the windows Scheduled task tried to run to warehouse the dataout of OnePoint, it would puke because the SQL log would fill up. Thisallows you to start so many days out and it will increment it down by the number of days […]
2007-10-18 (first published: 2007-07-26)
1,400 reads
Quick and accurate method to get the row count of each table in a given database. Execution time is dependent on the number of rows in each table.-- Girish (gvphubli)
2007-07-20
1,363 reads
This procedure produces a formatted report to list which tables, views and table functions have a column of the specified name. This is particularly useful in systems that do not enforce referential integrity or when schema changes are being evaluated.
2007-10-22 (first published: 2007-07-19)
4,171 reads
When changing schema or modifying an application it is often necessary to determine when a column from a specific table is used. This procedure produces a formatted report (when outputting from query analyzer or management studio in text mode) that specifies all of the procedures, views, functions and triggers that use the designated table.column.
2007-10-10 (first published: 2007-07-19)
7,434 reads
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
I have a WHERE clause I need to add to a list of other...
Hi, We are looking out to read parquet file directly from on premise shared...
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers