Viewing 15 posts - 47,716 through 47,730 (of 49,552 total)
Double post.
Direct replies to the following thread please - CPUs on a machine
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
January 10, 2008 at 10:36 am
Indeed there is.
exec xp_msver 'ProcessorCount' -- There are a lot of other options on msver. Well worth a look.
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
January 10, 2008 at 10:33 am
It depends whether the apps are connecting using the sa account, or if they have their own accounts.
In your favourite querying tool
select * from sysprocesses where spid>50 --(the where 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
January 10, 2008 at 10:25 am
I did some thinking on this whole discussion on the drive home.
Karthikeyan, no disrespect intended, but from what I've seen, you're probably better, at least for now, not worrying 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
January 10, 2008 at 10:19 am
bleighton (1/10/2008)
thanks for that... should have mentioned that I'm connecting to 2000... (crucial info missing)...
If you're using 2000, it's best to post in the SQL 2000 forums. In the 2005...
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
January 10, 2008 at 10:11 am
Arun T Jayapal (1/10/2008)
After that if condition I tried to drop the table. It said some syntax before drop. I believe you can truncate/drop temporary tables?
Could you post the exact...
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
January 10, 2008 at 10:01 am
The in-memory page structure (where rows are stored) is the same as the on-disk structure. That's why I pointed you at the storage engin posts.
Paul goes into a lot...
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
January 10, 2008 at 7:17 am
Can't see anything obviously wrong. Do you get the same if you run the two queries seperatly?
In your convert, replace the round bracket around Time with []. Might be related,...
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
January 10, 2008 at 7:09 am
I can't think offhand of a better way. Can you post all the index definitions for the table please.
You may want to consider making the index on PupilID unique. 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
January 10, 2008 at 4:45 am
Jerome (1/10/2008)
I also need to find myself in a higher position than I am rite now.
Put a large box under your chair. 😉 :hehe: :hehe:
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
January 10, 2008 at 3:27 am
The same way they get stored on disk.
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
January 10, 2008 at 2:52 am
Don't post entire blog articles here. It can be a violation of copyright, especially since it's not attributed. Could you please edit and remove it.
There are a lot of other,...
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
January 10, 2008 at 2:47 am
christophe (1/10/2008)
When I make it rank=count(*) SQL server struggles with the OVER keyword. I work via a SQL server management...
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
January 10, 2008 at 2:26 am
1) Get most of the research needed for my Masters complete. I'd like to be at the point of strting the write up by the end of the year.
2) Get...
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
January 10, 2008 at 2:24 am
Did you read the blog I referred you to?
Specifically look at the "Inside the storage engine" series he's written. It's explained far better than I could, and with diagrams...
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
January 10, 2008 at 2:09 am
Viewing 15 posts - 47,716 through 47,730 (of 49,552 total)