To check the Backup Status for an SQL Instance
This Script will fetch database backup information from msdb and give the idea about full, diffrential and log backup.
2014-01-10 (first published: 2014-01-04)
1,433 reads
This Script will fetch database backup information from msdb and give the idea about full, diffrential and log backup.
2014-01-10 (first published: 2014-01-04)
1,433 reads
Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.
2014-01-08 (first published: 2012-05-04)
4,028 reads
A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.
2014-01-07 (first published: 2012-03-14)
8,082 reads
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
4,342 reads
A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.
2014-01-03 (first published: 2013-12-10)
1,777 reads
Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).
2013-12-30 (first published: 2008-07-24)
45,426 reads
Get space for all user defined table information like size and row counts.
2013-12-27 (first published: 2007-08-29)
7,747 reads
Row counts and storage space information for all tables in the database. (SQL Server 2005).
2013-12-26 (first published: 2008-03-16)
17,082 reads
For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.
2013-12-24 (first published: 2007-11-06)
12,594 reads
2013-12-19 (first published: 2007-08-27)
20,955 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