Viewing 15 posts - 45,721 through 45,735 (of 49,552 total)
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...
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
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...
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
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.
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
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...
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
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...
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
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...
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
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...
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
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...
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
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...
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
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...
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
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)
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
July 14, 2008 at 4:08 am
Could you explain a bit more what you want? I'm not sure I understand your question.
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
July 14, 2008 at 4:04 am
Is the SQL service running on that machine?
Have a look in the server's error log, see if there's anything in there of interest.
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
July 14, 2008 at 4:04 am
MySQL or MS 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
July 14, 2008 at 3:57 am
The total scores page will answer some of those for 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
July 14, 2008 at 3:55 am
Viewing 15 posts - 45,721 through 45,735 (of 49,552 total)