Viewing 15 posts - 32,506 through 32,520 (of 49,552 total)
CLR?
Extended stored procs?
Linked servers?
What you're seeing is certainly possible. As I mentioned, the max memory sets the size of the buffer pool. SQL can and does use memory outside of...
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
June 11, 2010 at 6:56 am
What's the max memory set to, what's SQL using?
It is certainly possible, the max memory setting is for the buffer pool, SQL also uses memory outside the buffer pool 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
June 11, 2010 at 6:32 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
June 11, 2010 at 4:20 am
prashant.akerkar (6/11/2010)
As u mention when the Database is in suspect mode there will be no rollback / rollforward.
No, I said that a failed rollback/rollforward will result in a suspect database
1....
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
June 11, 2010 at 4:16 am
A database will go suspect is SQL cannot complete a rollback or rollforward operation, typically due to encountering log or data corruption during the rollback or rollforward.
When a database 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
June 11, 2010 at 1:07 am
Please post table definitions, index definitions and execution plan, as per 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
June 10, 2010 at 3:21 pm
sudhakar0683 (6/10/2010)
hi boss i mean to say lite speed is a third party tool but now microsoft has been taken that tool and inbuilt in sql server 2008
No they haven't....
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
June 10, 2010 at 1:04 pm
sudhakar0683 (6/10/2010)
wat is po and ap
PO is a purchase order. AP I assume has something to do with acquisitions. He's saying that he bought the product.
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
June 10, 2010 at 9:39 am
Grant Fritchey (6/10/2010)
GilaMonster (6/10/2010)
I recall grinning like an idiot for about three weeks.
I got in a little trouble at the insurance company for letting out a war whoop, leaping 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
June 10, 2010 at 9:35 am
sudhakar0683 (6/10/2010)
i mean to say that lite speed will come in built with sql server 2008 only
Litespeed's not built in to any version of SQL. It's a third party tool.
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
June 10, 2010 at 9:33 am
ALTER DATABASE <db name> SET SINGLE_USER
DBCC CHECKTABLE ('MyTable', REPAIR_REBUILD);
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
June 10, 2010 at 8:24 am
Dan.Humphries (6/10/2010)
I do not activly seek such things but I am not sure you would be able to wipe the smile off my face with a sand blaster.
I recall...
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
June 10, 2010 at 8:16 am
Click the 'My Posts' link (top, kinda central, underneath Logout)
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
June 10, 2010 at 8:15 am
Huh?
Sorry, don't understand what you're asking.
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
June 10, 2010 at 8:09 am
Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145834
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
June 10, 2010 at 7:55 am
Viewing 15 posts - 32,506 through 32,520 (of 49,552 total)