Viewing 15 posts - 19,846 through 19,860 (of 49,552 total)
Because select * from #t1 where id in(@p2) is completely and totally equivalent to select * from #t1 where id = @p2. Each item in an IN (variable, parameter or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2012 at 3:39 am
Steve Jones - SSC Editor (3/8/2012)
L' Eomot Inversé (3/8/2012)
If it were a non-USA site, then SOPA might apply;We are a non-US site. Based in the UK. 😀
However the way SOPA...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2012 at 1:00 am
No, nothing on catch-all queries in the simple-talk article. That's just about poor indexing. I always meant to write a follow-up about poor T-SQL. but could never decide what to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 1:44 pm
The backup from the source database - straightforward SQL native backup: BACKUP DATABASE ... with no 3rd party backup/compression tools of any form?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 9:58 am
Hang on....
SQL 2008 Standard Edition cannot take a compressed backup. In SQL 2008, only enterprise edition can take compressed backups, all editions can restore them. It's R2 that gave backup...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 8:51 am
Almost exactly the same as this question: http://www.sqlservercentral.com/Forums/Topic1263657-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 8:29 am
What exactly do you mean by 'encrypt the entire database'? Encrypt every column in every table? Encrypt the database files and backup files?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 8:27 am
Unlikely to have any noticeable effect.
My general thoughts around stuff like this is don't fall prey to premature optimisation. Test, measure, tune when necessary. A single missing index will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 8:23 am
Why is cross join not allowed?
For the comma-delimited list, look in the scripts library here for a string split function. I'd then cross apply the function to the table...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 7:23 am
Let's put it this way, if a operation fails or is cancelled and rollback cannot be completed, the database must be marked suspect immediately.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 7:21 am
I would probably use a recursive CTE with checks to see it I ever get dependant = starting value.
Give it a try (Books Online has some good resources on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 7:06 am
Recovery model does not EVER affect the ability to roll a transaction back.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 7:01 am
Sounds funny, but try copying the backup file back to the source and restoring it. Won't be the first time I've seen a backup file damaged during a copy.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 5:12 am
So you can restore it on the server you took it on?
Where did you try the restore verifyonly? On the source server or where you're trying to restore it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 4:51 am
shyamhr (3/8/2012)
In this case -- A(187) is dependent on B(188), B(188) is dependent C(189), C(189) is dependent on A(187). This create a dead lock here.
That's not a deadlock, that's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2012 at 4:15 am
Viewing 15 posts - 19,846 through 19,860 (of 49,552 total)