Total Database Information At Your Fingertips Part - II
This article will help to get some basic information from your databases that may help you in different situations.
2011-11-24
5,613 reads
This article will help to get some basic information from your databases that may help you in different situations.
2011-11-24
5,613 reads
SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.
2011-11-24
4,190 reads
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
2011-11-23
2,321 reads
We're looking to find out more about whether you monitor your databases, and how you do it. If you can spare a moment to complete a short survey, please click here.
2011-11-23
1,962 reads
Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article.
2011-11-22
4,331 reads
2011-11-22 (first published: 2010-03-17)
10,511 reads
There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.
2011-11-22
3,654 reads
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
2011-11-21
5,965 reads
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
2011-11-21
3,145 reads
Red Gate survey asks would you take cash or trip of a lifetime?
2011-11-18
1,525 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