Viewing 15 posts - 42,901 through 42,915 (of 49,566 total)
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...
November 27, 2008 at 4:51 am
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...
November 27, 2008 at 4:45 am
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....
November 27, 2008 at 4:14 am
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.
November 27, 2008 at 1:56 am
Maybe. Try attaching the database using the CREATE DATABASE ... FOR ATTACH statement.
Why no backups?
November 27, 2008 at 1:45 am
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...
November 27, 2008 at 1:43 am
Are you using native backups or 3rd party backup tool?
November 27, 2008 at 1:41 am
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
November 27, 2008 at 1:41 am
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...
November 27, 2008 at 1:04 am
krayknot (11/26/2008)
Use SET DEADLOCK_PRIORITY { LOW | NORMAL | @deadlock_var }
Why? What is that going to achieve?
November 27, 2008 at 12:59 am
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...
November 27, 2008 at 12:58 am
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...
November 27, 2008 at 12:57 am
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...
November 27, 2008 at 12:54 am
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...
November 27, 2008 at 12:50 am
Can you post one of the CREATE LOGIN statements that the script generated?
November 27, 2008 at 12:49 am
Viewing 15 posts - 42,901 through 42,915 (of 49,566 total)