2008-02-11
3,538 reads
2008-02-11
3,538 reads
2008-02-04
2,881 reads
2008-01-31
4,069 reads
Reindex all tables, showing statistics before and after reindexing, table name optional.
2012-03-27 (first published: 2008-01-30)
3,140 reads
2008-01-30
3,324 reads
Working with large images or other BLOB data can be a challenge for many DBAs. Andrew Sears brings us some code that can help you extract some of that data out of BLOBs and get it back into a more easy-to-work-with format.
2008-01-30
8,529 reads
2011-11-18 (first published: 2008-01-29)
2,953 reads
2008-03-14 (first published: 2008-01-29)
1,295 reads
A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.
2008-01-29
12,506 reads
Tool to automatically query combinations of columns in your table to determine candidate for unique key.
2012-08-21 (first published: 2008-01-28)
3,010 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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