In the last post, we have discussed about the auto create and auto update property of the statistics. Do we really need to do manual statistics maintenance to keep...
2013-07-03
72 reads
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we...
2013-07-09 (first published: 2013-07-02)
4,949 reads
This was my first time attending the AAW Symposium, hosted by the American Association of Woodturners. Here are some quick...
2013-07-02
788 reads
1. 3004
show the internal backup/restore operation for every step.
ex.
dbcc traceon(3004,3605,-1)
GO
3605 means output the message to errorlog. you can use 3604...
2013-07-02
4,669 reads
I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance...
2013-07-02
922 reads
Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...
2013-07-02
732 reads
Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to...
2013-07-02
2,302 reads
SQL Server Data Tools (SSDT) has a new update:
VS 2010: June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version:...
2013-07-02
2,126 reads
Today I got a chance to retrieve configuration information of sql server 2005 instances. PowerShell provide a facility to read...
2013-07-02
1,150 reads
Recently we observed a weird issue with SSRS export to Excel. One of the datetime column in the report was...
2013-07-02
1,990 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
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