Viewing 15 posts - 45,961 through 45,975 (of 49,552 total)
rbarryyoung (7/3/2008)
Woo-Hoo! Way to go Gail! :w00t:
<grin> :w00t: 😀
Despite the huge number of questions that she responds to, I don't think that I have ever seen her 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
July 3, 2008 at 10:05 am
Thanks all. It's kinda unexpected.
inus.dupreez (7/3/2008)
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
July 3, 2008 at 7:45 am
Kyle Neier (7/3/2008)
Clearly, Gail and Jeffrey are correct and I'm the one that should be apologizing.
No worries. We've all done similar or worse.
I appropriated your test code to show...
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
July 3, 2008 at 7:35 am
Jeffrey Irish (7/3/2008)
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
July 3, 2008 at 7:21 am
Jeffrey Irish (7/3/2008)
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
July 3, 2008 at 7:04 am
Jeffrey Irish (7/3/2008)
I thought that the chain continued regardless of whether you took a Full backup in the middle of the day or not.
You are correct, it does. Only a...
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
July 3, 2008 at 6:56 am
Steve Hindle (7/3/2008)
does this break the chain from the original backup and tran log backups?
No. Tran log backups chain from another. Full backups do not truncate the transaction log, only...
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
July 3, 2008 at 6:53 am
Ok. There's no real gain from passing the db name into the sp_executesql, as it can't be used directly as a variable (as you've seen) This simplifies things a bit
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
July 3, 2008 at 6:34 am
Thanks guys.
This site and everyone here is what made it possible.
Grant Fritchey (7/3/2008)
Holy cow, all the cool kids seem to be hanging out here now.
Careful, it seems 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
July 3, 2008 at 6:20 am
mahesh.kumar (7/3/2008)
If i create non-unique, non-clustered index and filter through registrationo wil it become faster.
Create the index on the registrationno column. It should be useful, depends on the queries...
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
July 3, 2008 at 5:44 am
select * from gpsdata_history1_April
That's going to table scan. It has to. You've asked for all the columns and all the rows, no filter. The only way that query can run...
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
July 3, 2008 at 5:03 am
kevriley (7/3/2008)
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
July 3, 2008 at 4:52 am
The capacity specs are listed in books online. to briefly summarise:
Database size 524,258 terabytes
Files per database: 32,767
File size (data): 16 terabytes
Rows per table: Limited by available storage
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
July 3, 2008 at 4:47 am
Rather create one database. The data volumes don't seem to be sufficient for the increase administrative complexity of multiple DBs
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
July 3, 2008 at 4:43 am
Thanks All
Christopher Stobbs (7/3/2008)
Well done Gail...It's good to see a fellow South African representing in the world of SQL 🙂
Where in SA you from?
Jo'burg. Are you coming to Teched next...
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
July 3, 2008 at 4:42 am
Viewing 15 posts - 45,961 through 45,975 (of 49,552 total)