Viewing 15 posts - 24,166 through 24,180 (of 49,552 total)
And if you are going to go that route, just restore the 2000 DB to 2008, then create secondary files/filegroups and rebuild the indexes you want to move onto the...
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
August 14, 2011 at 2:50 pm
IO Isolation is a very poor reason for that. System tables don't get high IO load.
The more sensible reason for going that route is so that you can do file/filegroup...
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
August 14, 2011 at 2:49 pm
Plugin list:
Akismet - Essential. 99% eliminates spam.
No Self Pings - Doesn't send ping backs to own site (I reference earlier posts often and I don't like that producing trackbacks)
Now Reading...
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
August 14, 2011 at 2:42 pm
Easiest way is probably with something like Redgate's SQLCompare. If buying that's not an option, drop the indexes on dev, script the create index statements from prod and run them...
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
August 14, 2011 at 2:16 pm
This, unfortunately, needs two correct options, not one.
From Books Online (SQL 2008 R2)
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set...
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
August 14, 2011 at 2:11 pm
try sys.dm_exec_connections. There's a column for the last sql handle (can't recall exact name, you'll recognise 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
August 14, 2011 at 9:41 am
The cert exams are set with the expectation that anyone writing them has 2-3 years of experience with whatever topic the exam covers...
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
August 14, 2011 at 4:26 am
Again, this has nothing to do with preference or best. It has to do with getting the correct results.
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
August 13, 2011 at 1:09 pm
nageshp (8/13/2011)
Gail,Am getting the same result when I select only col1 from both Left and inner join like the below
That means this is a very specific case, it is not...
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
August 13, 2011 at 12:25 pm
This has nothing to do with cost. It has everything to do with what's needed. If you need just matching rows, use an inner join. If you need all rows...
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
August 13, 2011 at 11:28 am
The inserted table has the same structure as the table the trigger is on, but only has the rows have been changed. Hence you would probably use it in place...
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
August 13, 2011 at 8:12 am
It has nothing to do with performance. Those two queries are not equivalent. You use the one that produces the results you need.
Inner join returns only matching records. Left join...
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
August 13, 2011 at 8:08 am
SQL Kidd (8/12/2011)
As for getting a low paying entry job with a cert of two????? Well, that is not an easy question to answer because there is an oversupply...
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
August 13, 2011 at 3:11 am
If that's the case, this is what you're looking for
homebrew01 (8/12/2011)
insert into EMPselect * from EMP_BKP
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
August 12, 2011 at 1:51 pm
NM
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
August 12, 2011 at 1:50 pm
Viewing 15 posts - 24,166 through 24,180 (of 49,552 total)