Viewing 15 posts - 16,486 through 16,500 (of 49,552 total)
Is there a trigger on that table?
That particular piece of code can't throw that error, as bhc.coreprocesstoken18 appears nowhere in the update statement.
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
September 24, 2012 at 10:18 am
Again, this is not a SQL Server error. This is not coming from the server, it's a client-side error coming from the client application. You cannot get a System.OutOfMemory exception...
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
September 24, 2012 at 10:14 am
That's not a SQL Server error. That's a .net error (SQL is not written in .net). It's the client machine that is running out of memory and the client app,...
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
September 24, 2012 at 9:36 am
It will.
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
September 24, 2012 at 9:34 am
Nerds????
Very hard to get the queries that return lots of rows. Getting ones that do huge numbers of reads is easier. Try
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
September 24, 2012 at 9:05 am
Agent will be down until MSDB is back online. All the job definitions, schedules, history, etc are in MSDB.
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
September 24, 2012 at 8:47 am
newbie2 (9/24/2012)
AND RTRIM(LTRIM(SD.Code ))<>'';
The RTRIM and LTRIM are unnecessary here. SQL ignores trailing spaces when checking string equality, hence '' = ' ', true no matter how many spaces...
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
September 24, 2012 at 8:42 am
laurie-789651 (9/24/2012)
FROM Table1 SD WITH (NOLOCK) JOIN Table2 WITH (NOLOCK) etc.
as long as the table isn't being updated - this saves time as no read...
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
September 24, 2012 at 8:06 am
For inner joins there is no difference whatsoever. For outer joins, moving the filter from where to join changes the logic of the query. Hence it's not a matter 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
September 24, 2012 at 8:03 am
Just that you don't have to detach the DB (which you can't do in some cases)
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
September 24, 2012 at 6:28 am
No the files aren't moved for you. You have to go and move them yourself.
As Perry said previously...
get the logical name and current path\filehame for each databases files that you...
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
September 24, 2012 at 5:22 am
Add OR nm IS NULL
Null never matches any value, so you cannot have null returned from a in or not in.
Your IN is expanded to this:
NOT (nm='a')
Now, the logical expression...
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
September 24, 2012 at 4:55 am
The location you set for either data or log does not match where you actually moved them 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
September 24, 2012 at 4:40 am
Is that the correct name of the data file?
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
September 24, 2012 at 4:15 am
gphemail (9/23/2012)
Here's the first example, which is the most obviously wrong....
Please note that as per the NDA that you accepted when writing the exam, you may not distribute or reproduce...
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
September 24, 2012 at 4:07 am
Viewing 15 posts - 16,486 through 16,500 (of 49,552 total)