Viewing 15 posts - 18,946 through 18,960 (of 59,072 total)
pcanino70 (12/14/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 16, 2015 at 2:21 pm
RonKyle (12/16/2015)
there are a lot of BI developers who simply won't move data using T-SQL tasks, even when you point out that it's easier to code and 10x as fast....
--Jeff Moden
Change is inevitable... Change for the better is not.
December 16, 2015 at 2:18 pm
ChrisM@Work (12/15/2015)
Jeff Moden (12/12/2015)
ChrisM@Work (12/10/2015)
Jeff Moden (12/9/2015)
ChrisM@Work (12/9/2015)
suvesh.sonker 2691 (12/9/2015)
-- Ten digitDeclare @field as varchar(20) = '559'
Select Replace(right(replicate(' ',10) + @field ,10),' ','0')
In what circumstances might this be preferable to...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 16, 2015 at 2:04 pm
Ed Wagner (12/16/2015)
WayneS (12/16/2015)
Jeff Moden (12/16/2015)
Steve Jones - SSC Editor (12/15/2015)
Jeff Moden (12/15/2015)
According to your blog, you might show up in Cleveland SQLSaturday for 2016. Any way of knowing...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 16, 2015 at 10:43 am
Steve Jones - SSC Editor (12/15/2015)
Jeff Moden (12/15/2015)
@steve-2,According to your blog, you might show up in Cleveland SQLSaturday for 2016. Any way of knowing for sure?
No, Cleveland is out....
--Jeff Moden
Change is inevitable... Change for the better is not.
December 16, 2015 at 7:22 am
Eric M Russell (12/15/2015)
Jeff Moden (12/15/2015)
larskandersen (12/15/2015)
This pattern can be replaced with a single “Upsert” on the source and destination...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 15, 2015 at 5:40 pm
According to your blog, you might show up in Cleveland SQLSaturday for 2016. Any way of knowing for sure?
--Jeff Moden
Change is inevitable... Change for the better is not.
December 15, 2015 at 3:10 pm
larskandersen (12/15/2015)
This pattern can be replaced with a single “Upsert” on the source and destination table. I find the merge...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 15, 2015 at 2:55 pm
suresh0534 (12/15/2015)
Sql Job - runs automatically when SQL Server Agent starts up is there any security risk.Please give me details.
Thanks
What does the job do?
--Jeff Moden
Change is inevitable... Change for the better is not.
December 15, 2015 at 11:05 am
Oh my... all that just to do a simple "upsert".
--Jeff Moden
Change is inevitable... Change for the better is not.
December 15, 2015 at 11:04 am
JohnG69 (12/15/2015)
The parameters are tablenames and columns. Right now, a Delphi software (procedure) has the same parameters and does it all withing the program. They want...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 15, 2015 at 8:06 am
ScottPletcher (12/14/2015)
Jeff Moden (12/12/2015)
ScottPletcher (12/10/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 15, 2015 at 8:04 am
jaquino012 (12/14/2015)
@jeff Moden
Yes, i have been working on a simple dictionary with a limited words and it is working fine.
but what if the words are so big the i cant...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 15, 2015 at 7:57 am
chaaarliship (12/13/2015)
you are Optimizing a table created at runtime with help of html . this process is very easy and simple , to learn html and...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2015 at 6:38 pm
I see nothing in your first two scripts that require any dynamic SQL whatsoever.
As for the 3rd script, I don't know why such a bit of "Catch All" C.R.U.D....
--Jeff Moden
Change is inevitable... Change for the better is not.
December 14, 2015 at 6:28 pm
Viewing 15 posts - 18,946 through 18,960 (of 59,072 total)