Viewing 15 posts - 45,811 through 45,825 (of 49,552 total)
Satya_skj (7/10/2008)
... unless there is a huge problem of disk storage free space.
In which case you get more disks. It's not as if storage is that expensive these days.
Shrinking 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
July 10, 2008 at 4:08 am
You'll find a few tools to decrypt if you use google. I don't have the links handy. I don't recall any of them been free.
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 10, 2008 at 12:29 am
If 030 is the name of the database, it needs to be in square brackets - [030]
That said, why are you truncating your logs? If you don't care about point-in-time...
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 10, 2008 at 12:26 am
Vijaya Kadiyala (7/9/2008)
Hi,Can any one give some simulation lins on this exam.
Thanks -- Vj
Asking for or using braindumps is against the rules of the exam and can get you certifications...
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 10, 2008 at 12:21 am
Triggers fire once per insert/update/delete, not once per row. Your line here
select @stokkod=stokkod,@quantity=quantity from deleted
Will fetch only one of the values from the deleted table, while there are as many...
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 10, 2008 at 12:19 am
Mani Singh (7/9/2008)
So you should consider running REINDEX after you shrink operations.
You shouldn't be shrinking your databases in the first 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
July 10, 2008 at 12:16 am
Ouch. Not a good layout.
The thing is, C, D, E are logical splits. They're the same physical devices and it means that IOs occuring on the swap file will impact...
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 10, 2008 at 12:08 am
The entire Inside SQL Server series is excellent. There are four books - the storage engine, T-SQL querying, T-SQL procgramming and Query tuning and optimisation.
The other one I'll recomend...
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 10, 2008 at 12:03 am
er.kalidass (7/9/2008)
Hi guysTry with snapshot isolation levels. it will reduce the db blocking Massively .
Agreed, snapshot isolation will completely prevent...
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 9, 2008 at 11:57 pm
CarlosHawes (7/9/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 9, 2008 at 11:52 pm
terry.jago (7/9/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 9, 2008 at 11:47 pm
Looks a lot better, but i think you still have a borderline IO bottleneck. What's your disk layout? (phycisal drives, RAID, file locations)
p.s. What are your memory setting now? (boot.ini...
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 9, 2008 at 11:42 pm
vikkin (7/9/2008)
Hi Where can I find this in SQL Sever, I ma having endless issues of Deadlocks
Where can you find what?
To trace the source of deadlocks. switch traceflag 1204 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
July 9, 2008 at 11:39 pm
GSquared (7/9/2008)
"physical universe reality".
Reality? What's that? 😉
Jeff Moden (7/9/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 9, 2008 at 12:56 pm
Dugi (7/9/2008)
Now, who is the best for you the MVP guy or the Engineer!???
Best for what?
Writing books?
Teaching a class?
Managing a database?
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 9, 2008 at 12:54 pm
Viewing 15 posts - 45,811 through 45,825 (of 49,552 total)