Gail Shaw

Forum Replies Created

Viewing 15 posts - 42,886 through 42,900 (of 49,552 total)

RE: about the sqlserver.20081121163006.dmp file

Not much point in contacting CSS. SQL 2000 is no longer supported. (unless your company has an extended support contract with MS that 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 4:53 am

#904242
RE: Are Table-Valued User Defined Functions the best way to handle calculations based on derived columns

Just one note. Multi-statement table valued functions do not and will not perform well with larger row sets if you are joining those functions together or joining them to other...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 4:51 am

#904241
RE: Can any body tell me reason to raise this error , and how can solved? ..Error Message : Executed as user: svr11\SYSTEM. Process is terminated due to StackOverflowException.The return value was unknown.The process exit code was -2147023895.The step failed.

That's not what I asked for.
Go into the maintenance plan designer and set that maintenance plan to log all output to a file. Run the plan again and then get...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 4:45 am

#904236
RE: Can any body tell me reason to raise this error , and how can solved? ..Error Message : Executed as user: svr11\SYSTEM. Process is terminated due to StackOverflowException.The return value was unknown.The process exit code was -2147023895.The step failed.

So native backups? You're not using litespeed or any other 3rd party tool?
If that error's raised by the native backups, then you're probably going to have to call customer support....
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 4:14 am

#904226
RE: 4000 character limit

jacques (11/27/2008)
a profile trace? whats that?
SQL Server Profiler. It's a tool that can trace events occurring on a SQL 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 1:56 am

#904182
RE: Can I restore a table in DB using .mdf & .ldf file

Maybe. Try attaching the database using the CREATE DATABASE ... FOR ATTACH statement.
Why no backups?
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 1:45 am

#904177
RE: 4000 character limit

Dunno. Depends on how the query's done in php.
If you run a profiler trace against the server, what are the command you see been run against the SQL server when...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 1:43 am

#904176
RE: Can any body tell me reason to raise this error , and how can solved? ..Error Message : Executed as user: svr11\SYSTEM. Process is terminated due to StackOverflowException.The return value was unknown.The process exit code was -2147023895.The step failed.

Are you using native backups or 3rd party backup 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 1:41 am

#904175
RE: How to detect "In Recovery"

You should be able to detect it using a query of sys.databases. I'm not sure how to create an alert based of that though
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 1:41 am

#904174
RE: can i improve performance in this query

Plan guides don't need changes to the source query. Basically, it's an object in SQL that tells the optimiser 'when you see a query of this form, apply these hints'
It's...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 1:04 am

#904172
RE: Deadlocks while updating rows in table

krayknot (11/26/2008)
Use SET DEADLOCK_PRIORITY { LOW | NORMAL | @deadlock_var }
Why? What is that going to achieve?
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 12:59 am

#904171
RE: How to clean up the cache and check what and all SQL statements in the cache.

Those commands will also drop all of the data pages from cache, forcing SQL to go to disk next time it needs data.
Do not run those on a busy production...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 12:58 am

#904170
RE: Deadlocks while updating rows in table

Traceflag 1222 is preferred over 1204 on SQL 2005 as it provides a lot more info. 3605 is not required for logging deadlock info to the error log.
To get deadlock...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 12:57 am

#904169
RE: Database Trigger

Not possible.
The only database-scoped triggers are the DDL triggers that fire on schema changes. DML triggers have to be placed on each table and will fire when that table 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 12:54 am

#904167
RE: 4000 character limit

ntext has a limit of 2GB. If the string is getting trimmed at 4000 characters, then it has something to do with how you're putting the data in or how...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 27, 2008 at 12:50 am

#904163

Viewing 15 posts - 42,886 through 42,900 (of 49,552 total)