2007-12-27 (first published: 2007-10-23)
1,057 reads
2007-12-27 (first published: 2007-10-23)
1,057 reads
Four bit manipulation functions:
1. Turn bit ON
2. Turn bit OFF
3. Check if bit is ON
4. Toggle bit ON/Off
2007-12-25 (first published: 2007-11-01)
1,119 reads
2007-12-21 (first published: 2007-10-25)
1,460 reads
This proc executing the update statistics command in all user tables (no system).
2007-12-20 (first published: 2007-10-24)
2,404 reads
2007-12-18 (first published: 2007-10-18)
2,709 reads
(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.
2007-12-13 (first published: 2007-10-11)
1,039 reads
2007-12-12 (first published: 2007-10-12)
3,590 reads
This script returns the defined rowlength and the actual datalength for the longest row in a table.
2007-12-10 (first published: 2007-10-01)
968 reads
2007-12-05 (first published: 2007-10-17)
711 reads
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2007-12-04 (first published: 2007-09-25)
2,713 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