NameSQLinConfioIgnite (SolarWinds DPA)
This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.
2014-02-05 (first published: 2014-01-25)
736 reads
This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.
2014-02-05 (first published: 2014-01-25)
736 reads
Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion
2014-02-03 (first published: 2014-01-21)
1,307 reads
This script calculates table row count and size(MB), as well as the used space and free space.
2014-01-31 (first published: 2014-01-17)
2,748 reads
2014-01-30 (first published: 2012-10-07)
2,218 reads
2014-01-28 (first published: 2013-01-16)
2,299 reads
2014-01-24 (first published: 2010-11-02)
27,367 reads
2014-01-21 (first published: 2013-12-28)
2,275 reads
2014-01-17 (first published: 2014-01-03)
1,797 reads
A simple script for automation of additional secondary data files of tempdb.
2014-01-14 (first published: 2013-12-27)
2,447 reads
This script will check the full backup time taken by all the databases of an SQL Server instance.
2014-01-13 (first published: 2014-01-07)
1,386 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