Viewing 15 posts - 40,381 through 40,395 (of 49,552 total)
Bob Hovious (3/12/2009)
I missed out on Babylon 5 🙁 It fell during a period of years where I never had time for TV.
It's available on DVD....
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:00 pm
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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:55 pm
I just went to an interview and...
full backup of the database filegroup is just like getting a full backup of the database
http://www.sqlservercentral.com/Forums/Topic674621-357-1.aspx
If he demonstrated that attitude in an interview, I...
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:54 pm
Bob Hovious (3/12/2009)
Hey Gail, where does your signature line come from? Is that original?
Hardly original.
We walk in the dark places no others will enter
We stand on the bridge and...
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:52 pm
frankivey (3/12/2009)
"Yes, with a full backup because full backup of the database filegroup is just like getting a full backup of the database", which is true
It is?
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:48 pm
Jack Corbett (3/12/2009)
Steve Jones - Editor (3/12/2009)
I'm just glad they're coming here instead of Google first 🙂As an MVP aren't you disappointed they didn't use Live search?:P
Live what?
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:36 pm
Stamey (3/12/2009)
It must be something in the way they calculate that number for it to be able to be so high with so few pages.
Fragmentation (for small and large indexes...
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:34 pm
Too small to defragment. The way pages are allocated in smaller indexes makes it impossible to defrag them. Besides it's unnecessary. Fragmentation starts to be an issue around 1000 pages.
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 12:08 pm
Roy Ernest (3/12/2009)
Why would people encrypt the stored proc when there are so many tools out there that can decrypt??:blink:
It's often done in 3rd party apps to make it 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 12:05 pm
J (3/12/2009)
Would you please provide some references where I could start on this?Regards
Check the Simple-Talk newsletter next week.
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 11:01 am
lmu92 (3/12/2009)
Even if it would be somebody who's completely new to SQL Server, those questions are unlikely to show up all at the same time...
I don't agree there. They look...
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 11:01 am
lmu92 (3/12/2009)
How can you be sure that the fragmentation question relates to indexing?
Context.
Why not Message Fragmentation in Service Broker? [Smile]
Why not File System fragmentation? Why not IP fragmentation? Why 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
March 12, 2009 at 10:55 am
How many pages does the index have?
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 10:19 am
prvreddy (3/12/2009)
Hi all,1)Why a table have maximum one clustered index ?
Because the clustered index is the table. The leaf pages of the cluster are the actual data pages of...
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 10:11 am
sql60190 (3/12/2009)
Sorry if I asked for too much. Forgot myself, really.
No worries. Asking isn't a problem.
As for the XML, make sure you're at least comfortable with 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 12, 2009 at 10:10 am
Viewing 15 posts - 40,381 through 40,395 (of 49,552 total)