Viewing 14 posts - 1 through 14 (of 14 total)
Glen (10/6/2008)
Default is 1024. I don't really know why did you change it to begin with...
That is a good question, I do not recall changing it manually and did...
October 7, 2008 at 7:52 am
Thank you guys for hints - I'll continue digging.
One question:Clients of our sql server perform a lot of very small queries. Every time they connect and disconnect, basically Login/Logout number...
October 6, 2008 at 3:06 pm
Jason Shadonix (10/6/2008)
Do you have any 3rd party backup/audit/etc. tools running on that box (Idera, RedGate, Apex, TSM, etc)?
The only thing we have running is Symantec Backup Exec. But according...
October 6, 2008 at 1:35 pm
Thx for suggestions.
However, I'm a bit concerned about lowering a memory. OS itself is very responsive during a problem. All counters within normal range. Page/Sec is 0.
Why do you think...
October 6, 2008 at 1:02 pm
Glen (10/6/2008)
Do you have AWE enabled?Can you verify the size and location of a paging file?
What is the version of Windows server? (standard, Ent.)
Yes, AWE is enabled
Paging file is...
October 6, 2008 at 11:06 am
Thanks for quick response, Glen!!!
Glen (10/6/2008)
Do you have /3GB switch in boot.ini?
/3GB is not in boot.ini - MS help desk says this is not required on 64bit platforms.
Glen...
October 6, 2008 at 9:37 am
I'd start from analyzing Wait Statistics and Locks.
January 12, 2004 at 11:20 am
I guess the easiest way would be to create a view or SQL statement which trims all those spaces and formats date like you want.
After that specify it like a...
October 31, 2002 at 9:28 am
You can use SQLExecMS.
Use Tools|Space Usage in main menu.
October 28, 2002 at 9:56 am
Since DEFAULT for column is defined as constant_expression then the only way to do it will be insteadof trigger.
October 28, 2002 at 9:50 am
Ok then,
could you tell me what is better to have
exculsive KEY lock or exlusive RID lock?
April 26, 2002 at 10:00 am
Here is the plan for nonclustered:
|--Table Update(OBJECT:([od_Test].[dbo].[A]), SET:([A].[TWO]=[Expr1004]))
|--Top(1)
|--Compute Scalar(DEFINE:([Expr1004]=Convert([@1])))
...
April 26, 2002 at 7:51 am
If there is ability to shut DB down then:
1.detach from orginal server
2.copy file(s) to new server
3.attach_db on new server
4.attach_db on original server
January 16, 2002 at 7:04 am
Viewing 14 posts - 1 through 14 (of 14 total)