Generate Column Metadata
This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.
2013-02-12 (first published: 2013-01-18)
775 reads
Scripts
Tables and rows listing
Simple script which create a list of all the tables and rows of the selected DB.
2013-02-11 (first published: 2012-12-21)
1,182 reads
2013-02-08 (first published: 2012-12-27)
1,555 reads
T-SQL Bulk Insert
T-SQL that allows you to import tab delimited text file into correct table based on file name.
2013-02-07 (first published: 2012-12-27)
2,339 reads
2013-02-06 (first published: 2012-12-27)
1,857 reads
Create and Populate a Date Dimension Table
Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes.
2013-02-04
3,314 reads
Change database compatability level of all databases
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
953 reads
List Database Users and their Corresponding Roles
Database Users and their Corresponding Roles and type login.
2013-01-28 (first published: 2013-01-16)
2,131 reads
Grouped Failover, a 2008R2 version of Availability Groups
One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.
2013-01-24 (first published: 2013-01-16)
593 reads
GetDateInString
This function will return a value of date if found within a string, the date format in the string will vary. If no date is found a null value is returned
2013-01-17 (first published: 2012-12-18)
1,283 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers