Viewing 15 posts - 29,146 through 29,160 (of 49,552 total)
Jan Van der Eecken (11/29/2010)
The bank hasn't changed yet, Gail. We are going live on the 16th with our phase 1C. Then nothing till 16 February.
Makes sense. Late Dec 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
November 29, 2010 at 7:45 am
Grant Fritchey (11/29/2010)
GilaMonster (11/29/2010)
Greg Edwards-268690 (11/29/2010)
Maybe they want to add some new enhancements.Nope. No new enhancements. I think that a Dec go-live interferes with vacation plans
Exactly! I regularly have 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
November 29, 2010 at 7:25 am
Greg Edwards-268690 (11/29/2010)
Maybe they want to add some new enhancements.
Nope. No new enhancements. I think that a Dec go-live interferes with vacation plans
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
November 29, 2010 at 6:55 am
What's the question?
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
November 29, 2010 at 6:04 am
In other news...
The project from hell (the one that I spent evenings, nights and weekends on to try and meet impossible deadlines) has had the go-live date pushed out 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
November 29, 2010 at 6:02 am
Please note: year old thread.
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
November 29, 2010 at 5:32 am
What's the fill factor for that index?
What's the default fill factor?
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
November 29, 2010 at 5:30 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1027234-1550-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
November 29, 2010 at 5:27 am
What's wrong with the straightforward approach?
SELECT a.col1, a.col2, b.col3, b.col4, ....
FROM table1 AS A INNER JOIN table2 AS B ON A.col1 = B.col3
If you use a temp table here you'll...
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
November 29, 2010 at 5:25 am
If there is no order by specified, SQL is under absolutely no obligation to return the data in any particular order. it depends what operators end up in the execution...
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
November 29, 2010 at 3:59 am
Honestly a pre-release version shouldn't be installed on a machine that you care about and are not willing to reinstall completely afterwards. Often the uninstall of the pre-release versions leaves...
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
November 29, 2010 at 3:50 am
What query did you use to query the DMV? What command (exactly) did you use to rebuild the index?
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
November 29, 2010 at 3:02 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1027192-146-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
November 29, 2010 at 3:01 am
Why are you worries about the log?
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
November 29, 2010 at 2:30 am
If you want to nitpick...
Full backups log the checkpoint start and end, the changes to the database boot page and a couple other things.
To grow a log that starts...
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
November 29, 2010 at 2:29 am
Viewing 15 posts - 29,146 through 29,160 (of 49,552 total)