Search for a specified GUID (or its part) in all databases (updated)
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
2011-02-21 (first published: 2008-01-24)
922 reads
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
2011-02-21 (first published: 2008-01-24)
922 reads
These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views.
2008-02-22 (first published: 2008-01-22)
1,279 reads
Created view displays all text columns' collations in the current database with the information whether
the collation is different from the database's one.
2008-04-04 (first published: 2008-01-22)
1,713 reads
This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.
2008-04-01 (first published: 2008-01-21)
1,209 reads
2008-02-27 (first published: 2008-01-21)
1,024 reads
This script maps the primary key - foreign key relations regardless if the column names are the same or not.
2012-05-15 (first published: 2007-11-07)
2,955 reads
2007-12-27 (first published: 2007-10-23)
1,012 reads
Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.
2007-10-08
9,115 reads
SQL Server guru Andy Warren brings us a list of things that he considers when things go wrong. Read about some of the common sense approaches to solving performance and other problems.
2007-10-03
4,591 reads
The Sarbanes-Oxley act has drastically changed the jobs of many DBAs with the audit and reporting requirements this act entails. Brandie Tarvin brings us some hints about how you can go about complying with the new requirements.
2007-10-01
3,795 reads
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Update for SQL Server 2025: This post and the GitHub repo have been updated for...
hi everyone I am getting an error when I add a variable to a...
Comments posted to this topic are about the item How to Use SQL Server...
Comments posted to this topic are about the item Choosing an AI in Sept...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers