2009-06-11 (first published: 2009-05-25)
789 reads
2009-06-11 (first published: 2009-05-25)
789 reads
This script is used to print the alter statement and also partition the table with the respective partition Scheme and Partition Function.
2009-06-10 (first published: 2009-05-22)
2,422 reads
Script to convert to N Columns the rows in a table with PIVOT Operator
2009-06-05 (first published: 2009-05-15)
2,037 reads
Here is a stored procedure that start a job, and then waits until the jobs is finished
2009-06-02 (first published: 2009-05-14)
1,084 reads
Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!
2009-05-29 (first published: 2009-05-05)
957 reads
2009-05-27 (first published: 2009-04-30)
2,627 reads
2009-05-22 (first published: 2009-04-28)
3,855 reads
The function is used to find non-printable ASCII characters in an input string.
2009-05-21 (first published: 2009-04-24)
3,028 reads
Lists the Databases and their Backups status in a neatly formatted HTML Email
2009-05-19 (first published: 2009-04-23)
3,019 reads
2009-05-14 (first published: 2009-04-08)
2,021 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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...
Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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