2010-09-08 (first published: 2010-09-02)
2,414 reads
2010-09-08 (first published: 2010-09-02)
2,414 reads
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,695 reads
This script changes the collation of columns to default database collation in all the tables
2010-09-02 (first published: 2010-09-01)
2,224 reads
A script to reveal which logins have access to your sql server via windows groups.
2010-09-01 (first published: 2010-08-26)
2,467 reads
Generates scripts to make text, ntext, varchar and char columns nvarchar/nchar
2010-08-30 (first published: 2010-08-26)
1,416 reads
2010-08-27 (first published: 2010-08-25)
3,722 reads
After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.
2010-08-26 (first published: 2010-08-19)
2,047 reads
Summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.
2010-08-24
88 reads
Fill a small Tally table with a 1 column primary key using GO keyword to repeat an insert.
2010-08-18 (first published: 2010-08-16)
1,575 reads
2010-08-16 (first published: 2010-03-05)
3,916 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers