Views dont parameters, but sometimes you need them to act as if they do. Andy discusses views and how they encapsulate code and then offers an idea about how to alter the behavior of views on the fly. Controversial? Probably!
2003-12-01
8,593 reads
This "script" truncates all user tables in a database (except dtproperties). It uses sp_msforeachtable stored procedure which cycles through each table in the database and performs the same query on each. Its useful in a number of different scenarios
2003-11-24
274 reads
New product designed to help you move from one database platform to another. (Not Reviewed)
2003-11-21
1,260 reads
Persons Names,Addresses or any other master information if not entered with proper case . I mean if some records are with All caps ,some with all small or any other combination.You may be able to convert this data to proper case. Which will help you to show it in better looks on websites or in […]
2003-11-19
509 reads
This article shows how to do conditional multiple table inserts. While it is more script than we typically display, it's interesting and might get you thinking about other uses for the idea.
2003-11-18
14,302 reads
This script starts in the master database, and then goes to each USER database and creates the DDL for each USER table in every database. You can then save the results or copy them to a new query window to run on another server.
2003-11-14
504 reads
This script will create another script that has all foreign key DDL that exists in a given database. You only have to run this, and then select the results of this script and paste it into another query window, or if for some reason you have lost your DDL this will enable you to retrieve […]
2003-11-12
253 reads
Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!
2008-05-09 (first published: 2003-11-10)
66,644 reads
This will make a comma seperated list from a column using 2 select statements.
2003-11-07
203 reads
We can use this sp to clear data in tables. I mainly created this sp for two reason. 1.This is useful to commence the testing from scratch. 2.Whenever we ask the database backup from our customer. They hesitant to give the production database because of confidential. I have used Delete and Truncate statement to clear […]
2003-11-06
180 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers