Viewing 15 posts - 3,886 through 3,900 (of 7,191 total)
DJ
What have you tried already? Have you read the "CAST and CONVERT" topic in Books Online?
John
August 15, 2013 at 4:43 am
Kev
That's curious. Are you sure they were user databases you moved and not system databases? I would expect absence of user database files to lead to the database...
August 15, 2013 at 4:36 am
You have collation differences between your four databases. You need to put a [font="Courier New"]COLLATE collation_name[/font] clause after every column specification that does not have the collation you want...
August 15, 2013 at 4:02 am
Interesting. The explanation ought to cite deferred name resolution as the reason it's possible to create stored procedures referencing non-existent tables. The paragraph from BOL quoted is not...
August 15, 2013 at 3:53 am
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
Viewing 15 posts - 3,886 through 3,900 (of 7,191 total)