2008-08-27
1,068 reads
2008-08-27
1,068 reads
2008-08-27 (first published: 2008-07-03)
2,224 reads
2008-08-26 (first published: 2008-07-09)
861 reads
Generacion de numero de registros y espacio usado en disco todas las tablas de la base de datos
2008-08-22 (first published: 2008-06-24)
555 reads
To import the SQL Server error log into a table, so that it can be queried
Written by: Anand Mahendra Tested on: SQL Server 2000
2008-08-21 (first published: 2008-06-30)
835 reads
2008-08-20 (first published: 2008-06-19)
1,167 reads
2008-08-18 (first published: 2008-06-25)
1,764 reads
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
2008-08-14
357 reads
Nothing fancy; just allows you to change a date the the first of the following month. Friend needed this so I thought I would post it here for other newbies.
2008-08-14 (first published: 2008-06-20)
572 reads
2008-08-13 (first published: 2008-06-17)
1,128 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...
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