Viewing 15 posts - 34,081 through 34,095 (of 49,552 total)
weitzera (2/10/2010)
To step back a bit, what I'm looking at are cases where letting the compiler implicitly cast the arguments results in an index scan instead of an index seek.
Most...
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
February 10, 2010 at 11:17 am
Can you run that and get me the actual execution plan? Way to do that's described in this article.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
February 10, 2010 at 8:32 am
Roger Abram (2/10/2010)
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
February 10, 2010 at 8:23 am
If you run a query twice in a row, the second will (very likely) have 0 physical reads because the data is cached.
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
February 10, 2010 at 8:19 am
Why? They identify log records. What's your interest in seeing them?
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
February 10, 2010 at 8:17 am
I wouldn't bother trying to attach it. The damage you have is not repairable in any way. Get out your backups and restore the DB from the latest backup.
The 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
February 10, 2010 at 8:09 am
amalanto (2/10/2010)
What's the definition of the Employees view?we have read permission to read all columns in the table belong to EmployeeInfo DB
That's not what I asked. Can you get 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
February 10, 2010 at 8:06 am
Vee (2/10/2010)
i believe it should beRESTORE DATABASE <suspecteddatabasename> WITH RECOVERY
Yes, however that does not fix a suspect database. It brings a database that's in the RESTORING... state 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
February 10, 2010 at 8:04 am
You can move data from one filegroup to another, but SQL manages where data goes if there are two files in the same filegroup. It uses a proportional fill algorithm.
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
February 10, 2010 at 7:41 am
What's the definition of the Employees view?
Which table do you want to index?
Why are you converting dates to strings?
Why are you using NoLock? Are incorrect results acceptable? See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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
February 10, 2010 at 7:38 am
The add new thread button is visible when you're in a forum. When you're viewing a thread you can reply to that 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
February 10, 2010 at 7:36 am
No, the difference between 32 bit and 64 bit is around memory addressing.
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
February 10, 2010 at 7:33 am
Not enough information.
You can do either, which will work better is another question. There's no way to answer that without seeing the query that you're tuning indexes for. From 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
February 10, 2010 at 7:10 am
32 bit, can only directly address 4 GB, has to use tricks to use more memory than that.
64 bit, flat addressable memory of millions of times more than any server...
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
February 10, 2010 at 7:07 am
From what I can see, you have system processes throwing high severity errors (severity 22).
I think reinstall would be a good idea, because I can't tell why or even what...
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
February 10, 2010 at 6:30 am
Viewing 15 posts - 34,081 through 34,095 (of 49,552 total)