Viewing 15 posts - 42,901 through 42,915 (of 49,571 total)
Sorin Petcu (11/27/2008)
Can anyone says something without referencing wikipedia? 😉
On this site, yes, frequently.
We reference Books Online and MSDN instead. 😀
November 27, 2008 at 6:02 am
If you have no primary keys (aside, why not?) then you cannot do transactional replication. You can use snapshot, which will copy the entire database over at scheduled intervals, but...
November 27, 2008 at 6:01 am
Happy normal working day to all the people in the rest of the world.
November 27, 2008 at 6:00 am
Any errors in the SQL error log?
Is this the first time that you've seen an IO error?
When you have a couple hours where the server won't be heavily used, please...
November 27, 2008 at 5:32 am
Not much point in contacting CSS. SQL 2000 is no longer supported. (unless your company has an extended support contract with MS that is)
November 27, 2008 at 4:53 am
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
Viewing 15 posts - 42,901 through 42,915 (of 49,571 total)