Script to grant exec permission to all sps in a db
Script to grant exec permission to all sps in a db
2010-12-13 (first published: 2010-12-09)
1,752 reads
Script to grant exec permission to all sps in a db
2010-12-13 (first published: 2010-12-09)
1,752 reads
know all database columns names and data types and lenght with the minimum effort
2010-12-09 (first published: 2010-12-06)
3,058 reads
2010-12-08 (first published: 2010-12-03)
2,005 reads
2010-12-07 (first published: 2010-11-30)
2,215 reads
2010-12-06 (first published: 2010-11-22)
2,639 reads
2010-12-03 (first published: 2010-11-22)
1,726 reads
A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.
2010-12-01 (first published: 2010-11-16)
1,720 reads
SQL Function to Split Comma Separated Values and Insert into Table
2010-11-30 (first published: 2010-11-07)
4,238 reads
2010-11-26 (first published: 2010-11-04)
597 reads
2010-11-24 (first published: 2010-11-02)
3,564 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