A Few Meta Data UDFs
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,108 reads
Articles
Executing a script from SQL Server
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
17,320 reads
2001-10-15
3,973 reads
2001-10-15
1,866 reads
2001-10-12
3,587 reads
Common SQL Server and Windows Clustering Questions and Problems
This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.
2001-10-11
13,662 reads
Review: Total SQL Analyzer
Total SQL Analyzer is a new product that can help document your SQL Server. This review examines the product and some of it's features.
2001-10-10
8,178 reads
Improve System Performance in Your Indexing Scheme Using Asynchronous
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.
2001-10-10
1,911 reads
A Few Mathematical UDFs
Alexander Chigrik presents a few Math UDFs he has developed for common functions.
2001-10-09
6,033 reads
2001-10-08
1,981 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers