Viewing 15 posts - 45,736 through 45,750 (of 49,571 total)
Post the table design, index definitions and some of the queries that deadlock with each other?
Have you considered snapshot isolation level?
A single table design is bad, but it might be...
July 14, 2008 at 7:59 am
Could you describe the ETL process a bit more please?
You may find it more efficient to copy the rows you want to keep to a temp table, truncate the...
July 14, 2008 at 7:58 am
Cursors = really, really bad idea
Could you describe what happens in a little more detail please?
July 14, 2008 at 7:45 am
Make sure you are not connected to the database you are trying to restore.
July 14, 2008 at 7:41 am
Carl Federl (7/12/2008)
[] are not supposed to change the meaning of a statement. They're supposed to just be delimiters.
But [] do change the meaning of SQL Statements.
Perhaps I should...
July 14, 2008 at 7:41 am
The only thing I can think of is that the cluster service fails to get a connection when trying to do an IsAlive check on SQL, concludes that the SQL...
July 14, 2008 at 7:27 am
It's your connection it's complaining about. To restore, there must be no users connected to the DB
Change to another database (master) before doing the restore.
July 14, 2008 at 7:22 am
Off hand, I don't know. I don't think it's 16 sec to compile. That's well over the maximum amount of time the optimiser would be allowed to work. Most likely...
July 14, 2008 at 7:02 am
Hari.Sharma (7/14/2008)
The best way to avoid SQL Injection is use of Stored Procedures.
The only way to 100% for certain avoid SQL injection is to use properly parameterised queries or stored...
July 14, 2008 at 6:54 am
Actually, I did suggest ISNumeric, with the warning that it's not perfect. Does your like allow for - and .?
Here's one that caught me very, very badly the other day...
SELECT...
July 14, 2008 at 6:51 am
Each differential backup is based off a full backup. You can only restore a diff if you have previously restored (with norecovery) the full backup that it is based off.
A...
July 14, 2008 at 5:29 am
The permissions that you have to the server is irrelevant. It's the account that SQL is running as that is important here.
What account is SQL Server running as?
Does that...
July 14, 2008 at 5:22 am
DKG (7/12/2008)
As per my understanding log file contains uncommitted transactions only, the transaction which is already committed has gone to datafile?
The transaction log contains records of uncommitted and committed transactions.
doest...
July 14, 2008 at 4:20 am
That very much depends on yout network infrastructure, not so much SQL. You may want to ask your network people about that
Is the SQL server in an internet-facing portion of...
July 14, 2008 at 4:12 am
If you're using SQL 2005 enterprise edition, you can do an online index rebuild
ALTER INDEX <Index Name> ON <Table Name>
REBUILD WITH (ONLINE = ON)
July 14, 2008 at 4:08 am
Viewing 15 posts - 45,736 through 45,750 (of 49,571 total)