Viewing 15 posts - 45,976 through 45,990 (of 49,552 total)
Please don't cross post. It just wastes people's time and fragments replies. many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic527823-338-1.aspx
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 2:14 am
Are you viewing this in management studio? There's a setting (Tools -> Options, expand out query results, SQL Server) that says how much data is displayed in text or grid...
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 2:12 am
humbleDBA (7/3/2008)
Congrats Gail. Well deserved 🙂
Thanks
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 1:06 am
From what you've said I'd recommend that you use one database and ensure that your code is written properly and your indexes are useful
How much data are we talking...
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 12:49 am
Please don't coss post. It just wastes time and fragments replies. Many of us read all the forums
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic527770-149-1.aspx
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 12:48 am
Sakthivel Chidambaram (7/3/2008)
Also what is the alternative for SHRINK DATABASE? You suggest to SHRINK FILE or something else?
I suggest that you don't shrink your databases at all. Databases tend...
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 12:40 am
Ouch. You have some nasty memory issues.
What's SQL's max and min memory set to?
Is there anything else running on that box?
2008-06-25 01:34:00.31 spid3 SQL Server 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 3, 2008 at 12:12 am
webrunner (7/2/2008)
My questions are:1. Is Query A equivalent in results to Query B?
To the best of my knowledge, yes
2. Is Query A faster than Query B?
Possibly. It depends 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
July 3, 2008 at 12:06 am
Don't shrink your databases.
Make sure that you have a good backup strategy
Make sure that you test your backups. A backup that you cannot restore is worse than no backup at...
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 12:02 am
Cuold you post all the code please. Including where @db coems from?
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 12:00 am
Jeff Moden (7/2/2008)
Track you down? Heh... I'm putting my Avatar on the back of a couple of shirts so I'll be easy to find. 😛
Not a bad idea....
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 2, 2008 at 11:50 pm
Jeff Moden (7/2/2008)
Mike C (7/2/2008)
I hear drinks are on Jeff? 🙂Only if you get real clumsy 😀
That can definitly be arranged. 😉
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 2, 2008 at 11:44 pm
Sounds like they really need you and really like you. Means, if you want to negotiate, you're doing it from a position of strength. There are worse positions to be...
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 2, 2008 at 2:24 pm
Agreed. Sorry, but I don't think we're going to be able to help very much here, except to offer commiserations and sympathy. Much as I'd love to dive into your...
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 2, 2008 at 1:59 pm
I've heard that the MS press self-paced training kit is very good.
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 2, 2008 at 1:19 pm
Viewing 15 posts - 45,976 through 45,990 (of 49,552 total)