Identity Column Increment Value (EVEN/ODD)
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-24 (first published: 2015-11-18)
4,891 reads
Chris
- Website: https://www.cjsommer.com/
Identity Column Increment Value (EVEN/ODD)
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-17
146 reads
Using Extended Events to Detect Connection Pooling
What is connection pooling? Lets start with a definition from MSDN.
Connecting to a data source can be time consuming. To...
2015-10-27 (first published: 2015-10-20)
5,256 reads
Using Extended Events to Detect Connection Pooling
What is connection pooling? Lets start with a definition from MSDN. Connecting to a data source can be time consuming....
2015-10-20
136 reads
Running Parameterized Queries against SQL Server using PowerShell
For many years I didn’t really think about the implications of how I was retrieving data from my SQL Servers...
2015-10-13
16,138 reads
Do you write ugly T-SQL?
Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...
2015-10-07 (first published: 2015-09-29)
6,379 reads
Pratical Use of a SQL Server Database Snapshot
I was doing a database code deployment the other night and the first step in the release plan was “Take...
2015-09-29 (first published: 2015-09-23)
7,348 reads
TSQL2SDAY #70: Strategies for managing an enterprise
Thanks to MidnightDBA (b/t) for hosting this month’s #tsql2sday.
Strategies for managing an enterprise.
What do you think of when you...
2015-09-17 (first published: 2015-09-08)
1,070 reads
How many errors can the PowerShell error buffer hold?
During my presentation at SQL Saturday Albany I was asked a question about the error buffer that I didn’t know...
2015-08-04
1,305 reads
Present at SQL Saturday #386 – Achievement Unlocked!
SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session
So that picture to the right is me out front of...
2015-07-28
718 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers