Viewing 15 posts - 40,396 through 40,410 (of 49,552 total)
sql60190 (3/12/2009)
So, those of you who have taken this exam, how important is this subject?
Fairly.
That's about all that can be said without violating the exam NDA.
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 12, 2009 at 9:59 am
ALTER DATABASE [Test_db]
SET OFFLINE
WITH ROLLBACK IMMEDIATE
Kicks everyone out and takes the database offline. Then you can restore over without worrying if there's anyone connected.
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 12, 2009 at 9:54 am
Hemalatha (3/12/2009)
If...
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 12, 2009 at 9:52 am
Depends. If the static and non-static can be on the same page, yes.
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 12, 2009 at 2:34 am
barcode (3/12/2009)
...and you're from South Africa - me too! I'm impressed.
Whereabouts? If JHB, there's a usergroup meeting next week tuesday. Interested? (details on my blog)
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 12, 2009 at 2:33 am
Chirag (3/12/2009)
Do you mean to say u put indexes on the columns and the query worked better?
He's talking about a different problem that I advised him on yesterday.
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 12, 2009 at 2:21 am
Glenn Dorling (3/11/2009)
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 12, 2009 at 2:20 am
Those are 3 distinct indexes, they can't be merged into one. (Difference leading columns)
Just check in a dev environment that they are actually useful before you go creating them 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 12, 2009 at 2:10 am
arun.sas (3/12/2009)
Is same works in 2k? If no means, how these handle by other way in 2k?
No. DDL triggers are SQL 2005 and higher.
To prevent people dropping tables, don't give...
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 12, 2009 at 2:05 am
An index is not going to help you there. All of those LIKEs have leading wildcards. An index seek is not possible when there's a leading wildcard. That query 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 12, 2009 at 2:02 am
Host_name is the machine name.
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 12, 2009 at 1:56 am
Just bear in mind that by setting a fill factor to 75%, your table is now taking a fair bit more pages. This means more space on disk, more space...
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 11, 2009 at 4:03 pm
tfifield (3/11/2009)
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 11, 2009 at 1:37 pm
SQL 2000 or SQL 2005?
This is the 2005 forum, but you mentioned SQL 2000. Which is 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 11, 2009 at 1:36 pm
There's also the row header, the null bitmap and the variable column offset to take into account. If the clustered index is not unique, you also have a hidden 4...
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 11, 2009 at 12:29 pm
Viewing 15 posts - 40,396 through 40,410 (of 49,552 total)