Viewing 15 posts - 34,306 through 34,320 (of 49,552 total)
Bitbucket, that proc will fail if the column PKey VARCHAR(30) is actually defined as a PRIMARY KEY. Cannot insert NULL into column will be the error.
Jeff
Why do you want to...
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 31, 2010 at 9:33 am
james_dmnds (1/31/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
January 31, 2010 at 9:24 am
Insufficient information to give you a guess, let alone best approach.
Please post query, 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
January 31, 2010 at 8:01 am
STherrien-978820 (1/30/2010)
What I'm really missing is when wait times are up and odd wait types pop on, what is causing the issues.
You need to run a trace, bottom line....
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 30, 2010 at 11:30 pm
If it's a job, are you logging the job output? Might be in there.
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 30, 2010 at 11:30 pm
There's no silver bullet. There's no app that will make your problems go away. There's no setting that will make everything better.
If this is critical and costing you reputation with...
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 30, 2010 at 2:10 pm
3rd party backup tool? Check that application's log.
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 30, 2010 at 12:11 pm
Bhuvnesh (1/29/2010)
SELECT CONVERT(VARCHAR(10),log_date,101),avg(event_duration) respTime from log_event nolock
where....
I'm assuming that it isn't a problem that this query may return inaccurate results
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 30, 2010 at 11:29 am
Jeff Moden (1/30/2010)
Was that the actual execution plan or the estimated execution plan attached in the first post?
Estimated plan. In an actual plan there will be both estimates...
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 30, 2010 at 11:28 am
SQL Server is a server application, it runs as a service on a machine. It's not like MS Access.
If you want to play, you can download SQL Server Express (free)...
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 30, 2010 at 10:31 am
CirquedeSQLeil (1/30/2010)
I noticed that the MVP nominations allow for the same thing. (I know different topic - sort of.) Do people nominate themselves for that too?
Yes. I know...
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 30, 2010 at 10:16 am
dba-vb (1/30/2010)
1. If windows server is 32-bit then Virtual Address Space is 4GB(V.S.)And RAM is <4GB then No need to enable AWE?
if >4GB then we should enable AWE?
Yes.
btw,...
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 30, 2010 at 9:46 am
george sibbald (1/30/2010)
expect an entry from me next year!
I look forward to it. 😛
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 30, 2010 at 9:35 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
January 30, 2010 at 5:14 am
dba-vb (1/30/2010)
If production system is having 16GB RAM then is it required to AWE ON?
Depends. 32 bit or 64 bit?
i.e., if my RAM SIZE IS GREATER THAN V.S. then only...
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 30, 2010 at 5:14 am
Viewing 15 posts - 34,306 through 34,320 (of 49,552 total)