Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.
2008-10-24 (first published: 2008-08-01)
2,142 reads
2008-10-23
1,465 reads
2008-10-23 (first published: 2008-08-24)
1,922 reads
2008-10-22
1,318 reads
Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.
2008-10-22 (first published: 2008-08-05)
1,179 reads
Feed it delimited horizontal data and it returns it back as a vertical table.
2008-10-20 (first published: 2008-08-05)
2,714 reads
This one line DOS script fetches Hardware Make and Model
OS Name, Edition (for 2003) and version
System Uptime
Processors,
RAM etc.
2008-10-20
375 reads
This small script help u to find the column exists in the list of tables in a database.
2008-10-17
909 reads
Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.
2008-10-17 (first published: 2008-08-01)
3,338 reads
2008-10-16 (first published: 2008-08-12)
1,465 reads
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
WhatsApp 082225313145 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
WhatsApp 082225313145 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Comments posted to this topic are about the item Admin Rights for Everyone
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers