Forum Replies Created
Viewing 15 posts - 9,451 through 9,465 (of 9,725 total)
-
RE: Using the Quote feature in these forums
This is a test of the quote box system...
Aha... " 'I see,' said the blind man to his...
-
RE: Why FREETEXT is not working ?
Your best bet is to drop the index and rebuild it if you're not sure it's created correctly. There is no way, that I know of, to check and verify...
-
RE: How to Set Recovered DB back to restoring mode
Just an FYI, you cannot restore transaction logs after a different full backup than the particular full backup you are using for your restore.
The reason is because of the...
-
RE: TableSample vs Top x Percent
Actually, the reason I tested TableSample without the Percent was to see if it did rows and it definitely does not. I don't even think it converts to a percentage...
-
RE: Using the Quote feature in these forums
But that doesn't put the quote into the little Quote window, does it?
At least, I haven't been able to make it work.
Here's what I'm doing. I go to someone's post,...
-
RE: Is SQL aware of VERITAS?
mforbes, I know that. That was my second comment. My first comment or question is this:
Veritas can backup everything on the Server. So, it backs up the OS, the folder structure...
-
RE: Is SQL aware of VERITAS?
Or, horror of horrors, the team is re-imaging the entire server which would "convienently restore" SQL Server to the state everything was in at the time Veritas took its snapshot...
-
RE: Efficencies of ORDER BY
AHA! Now that's an argument I can use.
Thanks, Steve. @=)
Darnit... Can't get the quote thing to quote the line I wanted to quote... Meant to quote "Also, what about...
-
RE: Stored Procs - 4 part naming
Ahhh. Good one, Rudy.
Forget dynamic SQL. Use Rudy's suggestion. It'll save you having to change even the linked server connection / alias if the hardware changes.
-
RE: If Exists...Drop Table not always working...
Andras,
I just noticed that myself... GAH! I'm working on so many bug fixes today that I feel like I left my brain at home. I am such a Ditz sometimes....
-
RE: If Exists...Drop Table not always working...
I still don't understand why ObjectID() would make a difference with non-temporary tables. It just happened to me again....Sortof. Now in the opposite way...
If exists (Select name from MyUserDB.sys.objects where...
-
RE: Efficencies of ORDER BY
Unfortunately, the Upgrade Advisor article in BOL doesn't actually say what might be depreciated in future versions of SQL Server. And I actually need quotable text to give to the...
-
RE: Efficencies of ORDER BY
Maybe that's what I saw. Information on the numeral version being depreciated... Ninja, do you have a source for that?
Thanks,
-
RE: help with Delete statement
If you're aliasing a Delete table for a join, the same principal works. Example:
Delete from MyTable
from MyTable t1
join OtherTable t2
on t1.A = t2.A ...
Basically, you have to list the FROM...
-
RE: Stored Procs - 4 part naming
Are you talking about in the text of the proc or in the actual proc name?
You can write a T-SQL statement that pulls the name & Text of the Procs affected...
Viewing 15 posts - 9,451 through 9,465 (of 9,725 total)