Shrinking all log files on SQL Server 2008R2
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,968 reads
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,968 reads
2012-10-30 (first published: 2012-10-12)
2,346 reads
This stored procedure helps you list all tables, stored procedures, functions, view and triggers in a database.
2012-10-29 (first published: 2012-10-03)
1,911 reads
2012-10-26 (first published: 2012-10-02)
989 reads
2012-10-25 (first published: 2012-10-12)
1,966 reads
2012-10-23 (first published: 2012-09-12)
3,011 reads
A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.
2012-10-22 (first published: 2012-09-11)
2,084 reads
Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.
2012-10-19 (first published: 2012-09-17)
1,166 reads
Here's a set of scripts that allow you to save pertinent information from SQL Server Profiler trace files.
2012-10-18 (first published: 2012-09-20)
652 reads
Generates a script to check connectivity between a list of SQL Server instances on a specified port.
2012-10-17 (first published: 2012-08-09)
2,166 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