Viewing 15 posts - 46,726 through 46,740 (of 49,552 total)
It is possible to force the type of join (nested loop, merge, hash) you want, however, unless you really understand how the different joins work, when the different types are...
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
May 5, 2008 at 2:20 am
- becuae the coffee in Seattle is soooo very good.
- because it's a good opportunity to renew friendships with the people you met last conference
- because you'll never complain about...
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
May 5, 2008 at 2:03 am
ALTER TABLE <Table name> ALTER COLUMN <Column name> <New data type>
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
May 5, 2008 at 1:17 am
If you do a Restore Headeronly, you get a resultset with details on each backup that's contained within the file. The DB name is one of the things returned.
restore headeronly...
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
May 5, 2008 at 12:57 am
Are the files read only? (if you copied them using CD/DVD it's very likely they are)
Are the files in a compressed or encrypted directory?
What happens if you run
ALTER 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
May 4, 2008 at 3:56 pm
How big are those tables? How many pages?
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
May 4, 2008 at 3:30 pm
Certain sp_configures also flush the cache. I don't know offhand which ones. In SQL 2000 prior to SP4 (I think) it was all changes done using sp_configure
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
May 4, 2008 at 3:27 pm
There's a whitepaper on best practices for TempDB. I'll see if I can find it, I think I have the link at the office,
Regarding the separate drives, 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
May 4, 2008 at 3:24 pm
colin Leversuch-Roberts (5/4/2008)
I'm thinking about a post/page about x32 memory - I thought that this subject was old hat these days but obviously not!
Please do. It would 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
May 4, 2008 at 3:13 pm
Colin: do you have a good article/blog post that explains /3gb, /pae and AWE on 32 bit systems?
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
May 2, 2008 at 1:42 pm
All /3gb does is change the normal division of the virtual addressable 4 GB (all that's directly addressable on 32 bit) from 2GB for user processes and 2 GB for...
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
May 2, 2008 at 1:33 pm
Not sure, but maybe put the SET ROWCOUNT inside the dynamic SQL.
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
May 2, 2008 at 9:59 am
Or on SQL 2005, SELECT min(login_time) FROM sys.dm_exec_sessions
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
May 2, 2008 at 9:56 am
Unless he knows enough about SQL to start it in single user mode.
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
May 2, 2008 at 9:42 am
schep021 (4/25/2008)
The plan is to set the max server memory to 6.5GB and min server memory to 1GB. I think all we need for switches is /3GB since the...
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
May 2, 2008 at 9:40 am
Viewing 15 posts - 46,726 through 46,740 (of 49,552 total)