SP_SPACEUSED & SP_MSTABLESPACE
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,567 reads
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,567 reads
A quick info where you can find the Maximum specification for SQL Server 2008/2005 (32 bit & 64 bit).
SQL Server 2008...
2010-03-21
1,261 reads
Since the early versions of SQL Server, from version 6.5 we can know and
determine the latest version that we...
2010-03-20
1,098 reads
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
2010-03-20
2,831 reads
SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
The content of this update includes 11 Presentations, 17...
2010-03-06
627 reads
There it is the SQL Server Migration Assistant or SSMS for MySQL, it comes for both versions SQL Server 2008...
2010-02-20
1,888 reads
This is a good news from the Microsoft about SQL Server Release Services for both versions SQL Server 2008 & 2005.
SQL...
2010-02-19
665 reads
It is a good news for developers! Microsoft published the Training Kit for SQL Server 2008 R2.
The content of...
2010-02-05
598 reads
Let me show you another free tool for SQL Server that is very usefull and thanks from the companies that...
2010-02-05
1,143 reads
I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the...
2010-01-21
392 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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