Viewing 15 posts - 3,886 through 3,900 (of 7,187 total)
bgrossnickle (8/14/2013)
Ok, I would like to uninstall data tools and reinstall. Right now VS 2010 shell launches. (There is not another...
August 15, 2013 at 1:13 am
Right-click on the server name in Management Studio and choose Properties.
John
August 14, 2013 at 8:33 am
Difficult to see what you're trying to do here, since your TradeDiscDealLevelSummary CTE attempts to select from itself.
John
August 14, 2013 at 5:41 am
Put your server names in a table on a central server, and use a For Each Loop container to loop through them and change the connection string each time. ...
August 14, 2013 at 5:32 am
You can use an SSIS package to loop through all your servers, or you can use the Central Management Servers feature in Management Studio. I'm sure there are other...
August 14, 2013 at 5:12 am
By the way, why are you using a table variable at all? If your database has a lot of tables, you're pulling out a lot of rows that you're...
August 14, 2013 at 4:31 am
gsc_dba (8/14/2013)
Having had a brief look, the second query (on my PC) was better in terms of CPU and fewer reads.
Yes, same for me. But this one blows them...
August 14, 2013 at 4:06 am
Andreas, that page is about merge replication with a SQL Server Compact 3.5 subscriber. Is that what you have? If so, I'm afraid I'm a little out of...
August 14, 2013 at 2:50 am
Andreas
I don't understand. If you're talking about dropping an index, why do you need to worry about a reorg or rebuild? What indexes does the table have (clustered/non...
August 14, 2013 at 2:25 am
You have killed it. Now you just have to wait for it to die. If you try to kill it through Windows, you have two options:
(1) Kill the...
August 14, 2013 at 1:58 am
The solution is to wait. The transaction has to be rolled back in order to leave your database in a transactionally consistent state. This can take time depending,...
August 14, 2013 at 1:48 am
You're the DBA. Just say no if the request isn't appropriate.
John
August 14, 2013 at 1:40 am
Still not clear. How about this?
skDte >= '20110101'
If that's not what you require, please supply table DDL (CREATE TABLE statement), sample data (INSERT statements) and expected results.
John
August 14, 2013 at 1:35 am
That seems to work... as long as you remember to close your quotes!
By the way, sysobjects is there for backward compatibility only. You should use sys.objects, sys.tables or INFORMATION_SCHEMA.TABLES...
August 14, 2013 at 1:31 am
Viewing 15 posts - 3,886 through 3,900 (of 7,187 total)