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)
776 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,183 reads
2013-02-08 (first published: 2012-12-27)
1,556 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,315 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)
595 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
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Forums
Nomor Resmi Akun WhatsApp Bank BCA (0818751777)
WhatsApp resmi Halo BCA tersedia di nomor 0818751777. Layanan ini dapat digunakan untuk mendapatkan...
Layanan Halo BCA 24 Jam - Nomor Resmi 0818751777
Layanan Halo BCA dapat dihubungi melalui nomor resmi 0818751777. Layanan ini mencakup bantuan terkait...
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers