Viewing 15 posts - 5,896 through 5,910 (of 8,761 total)
Quick question, can you provide the table structures (DDL), some sample data and the actual execution plan?
😎
March 31, 2015 at 12:22 pm
Quick question if I may, why installing SQL Server 2005?
😎
March 31, 2015 at 1:12 am
nick 51459 (3/31/2015)
Thanks but no joy.When I open the Attach Database dialogue box to locate a database, no files appear in the window.
This tells me that the permissions have not...
March 31, 2015 at 12:45 am
Quick thought, check the file/folder permissions and make certain thar the Sql Service can access the files.
😎
March 30, 2015 at 10:46 pm
SQL_Kills (3/29/2015)
A0001 still needs to appear as 50 as a Difference for the InjectedDate 2015-03-05 23:19:01.727
Quick question, do you mean that you want to add missing entries as zero value,...
March 30, 2015 at 10:33 pm
swchoi.choi (3/30/2015)
I have been told that when you run a sql statement on a database, it doesn't actually update the table. It's committed to a log. Is this true ?
Think...
March 30, 2015 at 1:17 pm
Steve Jones - SSC Editor (3/30/2015)
Jeff Moden (3/27/2015)
BWAAA-HAAA!!!!! SPAM REPORTED!!! 😀
Ha, you're jealous because I ignored Detroit.
Nah, he knows better;-)
😎
March 30, 2015 at 1:06 pm
Steve Jones - SSC Editor (3/30/2015)
I do try to provide good code samples with semi-colons in them to help...
March 30, 2015 at 1:03 pm
Nevyn (3/30/2015)
-- Do some magic
This reminded me of a comment I used to use as an "off-limits marker" in the old days
/* HC SVNT DRACONES */
😎
March 30, 2015 at 11:51 am
Tossing in my 2 Cents, I feel the NULL/Nothing/Unknown/Empty discussion is digressing towards the ancient NULL debate.
😎
Given the un-pivotal nature of the function, which produces a pseudo table with...
March 30, 2015 at 11:45 am
TomThomson (3/30/2015)
Jeff Moden (3/30/2015)
March 30, 2015 at 11:31 am
Jeff Moden (3/30/2015)
Jason-299789 (3/30/2015)
I would also suggest that the key on both the destination table is clustered it should make the process significantly faster. so something like.
"It Depends". Unless...
March 30, 2015 at 11:20 am
Luis Cazares (3/30/2015)
Eirikur Eiriksson (3/30/2015)
;With due respect, additional and extra semicolons between statements will not cause any problems and CTE statements will run, without the semicolon it will not.😎
I beg...
March 30, 2015 at 9:00 am
Viewing 15 posts - 5,896 through 5,910 (of 8,761 total)