Viewing 15 posts - 43,051 through 43,065 (of 49,552 total)
Something like this.
SELECT col1, col2, col3 from
t1 inner join (select col1, col2, col3 from t2) t2 on t1.col1 = t2.col1
I'm not sure I understand what you're doing. Please can you...
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 20, 2008 at 4:16 pm
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/Topic606008-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 20, 2008 at 2:11 pm
Try moving the subquery into the from clause and treating the subquery as a table.
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 20, 2008 at 2:09 pm
What do the tables look like? What are the 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
November 20, 2008 at 2:07 pm
Test, test, test....
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 20, 2008 at 2:03 pm
yulichka (11/20/2008)
Thank you This is 2000 and there is no option for that.
Then read up on DBCC DBREINDEX
Please post in the correct forum from now 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
November 20, 2008 at 2:02 pm
Databases need free space within them. They're not like word documents where white space is wasted. You should leave a fair amount of free space within the data file. 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
November 20, 2008 at 2:00 pm
Garadin (11/20/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
November 20, 2008 at 10:46 am
yulichka (11/20/2008)
How you do that?
How do you do what? Rebuild indexes?
Look up ALTER INDEX in books online.
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 20, 2008 at 10:38 am
yulichka (11/20/2008)
How can I check how long I was shrinking a database. Is there a log to check or script to run?
Why are you shrinking the 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
November 20, 2008 at 10:38 am
Script out the logins, with their sids and apply that script on the new server, then you can detach and attach the database without the users been orphaned.
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 20, 2008 at 10:34 am
Sorts are expensive operations and distinct requires a sort, as do most other methods of removing duplicates from a resuuklt set.
The best 'workaround' is to find out why there...
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 20, 2008 at 10:27 am
Depends. How big is your database? How fast does it grow?
You shouldn't ever shrink a database. By doing so you've fragmented all of your indexes. I would strongly suggest you...
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 20, 2008 at 10:25 am
Mark (11/20/2008)
3) Remove builtin\administrators group
Just make sure there's another sysadmin account before doing that.
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 20, 2008 at 10:18 am
bkirk (11/19/2008)
Of course that is a very simple solution, however we need to keep it active for regular updates using 'sa' login.
Why? Quite frankly, as far as I'm concerned,...
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 20, 2008 at 10:09 am
Viewing 15 posts - 43,051 through 43,065 (of 49,552 total)