Viewing 15 posts - 11,416 through 11,430 (of 15,376 total)
What is wrong with backup and restore? It by far the easiest and safest way to do this.
July 5, 2012 at 10:03 am
I am guessing you will have better luck on a java forum since this is clearly an issue with java connecting to sql. 😉
July 5, 2012 at 8:39 am
Duplicate post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1325233-392-1.aspx
July 5, 2012 at 8:04 am
hope your ID celebration was up to par 🙂
If by that you mean the Sporting KC win last night then I would say my celebration was up to par. 😉
July 5, 2012 at 7:56 am
Have you looked into EXCEPT? http://msdn.microsoft.com/en-us/library/ms188055.aspx
July 5, 2012 at 7:54 am
You have procs running sporadically slow sometimes the two most likely candidates are blocking and parameter sniffing. Take a look at Gail's article about parameter sniffing.
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D
Make sure you read all...
July 5, 2012 at 7:20 am
pwalter83 (7/5/2012)
Sean Lange (7/3/2012)
Start with this from Gail. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5DHi Sean,
Would you be able to help me now ?
Thanks,
Paul
Sorry yesterday was a holiday here in the US. It looks like Chris...
July 5, 2012 at 7:05 am
SQLBill (7/3/2012)
SQL_ME_RICH (7/3/2012)
What did the one SQL table say to the other SQL table at the bar this past Friday night?:w00t:
Sorry, that's an old one that's been on this site...
July 3, 2012 at 3:32 pm
GilaMonster (7/3/2012)
For anyone not on/not paying attention to twitter.....It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.
https://twitter.com/SQLintheWild/statuses/220252281847808001
Congrats Gail. That is certainly something to be excited...
July 3, 2012 at 3:26 pm
SQLRNNR (7/3/2012)
Brandie Tarvin (7/3/2012)
GilaMonster (7/3/2012)
Brandie Tarvin (7/3/2012)
Anyone got a fresh brain I could borrow? I promise to return it with only a slight bit of wear.
Sure. Will you finish off...
July 3, 2012 at 2:20 pm
OK your description is still incredibly vague but I think that you are asking if you call a scalar function from within a trigger can you see the newly inserted...
July 3, 2012 at 2:19 pm
jitendra.padhiyar (7/3/2012)
Sean Lange
Do you mean an identity? You can make an identity the primary key but just being an identity does not work because an identity can have duplicates.
That...
July 3, 2012 at 2:02 pm
No need for that. Here is some code that works perfectly in SQL.
;with Details(ChargeDescription, Charge, Weight)
as
(
select 'wrong address', 5.00, 2 union all
select 'wrong address', 5.00, 3 union all
select 'wrong weight',...
July 3, 2012 at 1:50 pm
jitendra.padhiyar (7/3/2012)
Sean Lange (7/3/2012)
July 3, 2012 at 1:41 pm
It makes sense if you think about it. You are talking about pushing modified rows contents to another database. Without a primary key how do you know which row is...
July 3, 2012 at 1:13 pm
Viewing 15 posts - 11,416 through 11,430 (of 15,376 total)