SQL Saturday #114 - Vancouver
A free day of SQL Server training in Vancouver, BC, Canada on Mar 17, 2012.
2012-03-06
1,373 reads
A free day of SQL Server training in Vancouver, BC, Canada on Mar 17, 2012.
2012-03-06
1,373 reads
A free day of SQL Server training in Lisbon. Register and come if you can.
2012-03-06
1,289 reads
The challenge is to transform monthly resource efforts into weekly actuals.
2012-03-05
763 reads
When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.
2012-03-05
4,231 reads
2012-03-05
1,402 reads
Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from SQL. How does he do it? In the first of a series of articles, Peter explains his secrets.
2012-03-05
4,317 reads
The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.
2012-03-02 (first published: 2010-09-22)
145,201 reads
When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in T-SQL as Feodor Georgiev explains.
2012-03-02
2,397 reads
How to change the port number for connections to SQL Server.
2012-03-01
13,762 reads
In this tip we cover what CONTROL SERVER is, how to detect its use and a possible way to exploit this permission.
2012-03-01
2,469 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