Connecting to a Remote Instance of SQL Server Using Python
SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...
2017-10-18
1,231 reads
The perils of RAID
Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...
2017-10-18
653 reads
Does Your Code Have a Preamble?
Okay, here is a pet peeve of mine, I think every stored procedure, function, view etc. should all contain a...
2017-10-18
517 reads
And YOU Get a Deadlock and YOU Get a Deadlock and EVERYBODY GETS A DEADLOCK!
https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpgWe all get them at one point or another - deadlocks.
I have Object 1 and need Object 2, you have Object...
2017-10-26 (first published: 2017-10-18)
3,609 reads
Updateable CTEs
CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t...
2017-10-18
1,978 reads
Are your disks formatted with UseLargeFRS?
PureStorage has a pretty cool post that mentions the importance of formatting SQL Server disks with a 64KB clusters and...
2017-10-18
2,781 reads
Linked Servers and Stats
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for...
2017-10-17
257 reads
Linked Servers and Stats
Linked Servers
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and...
2017-10-17
1,524 reads
Automating Everything with PowerShell – Getting Started #tsql2sday
I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other...
2017-10-17
911 reads
Bug with STATISTICS TIME?
I love the STATISTICS IO and STATISTICS TIME commands. They are such a powerful and easy way to be able...
2017-10-17
531 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