Viewing 15 posts - 2,221 through 2,235 (of 7,484 total)
Koen Verbeeck (9/11/2014)
Please don't say truncate table data isn't logged unless you understand the concepts involved.😉
+1000000
It's amazing, when even the reference quoted...
September 11, 2014 at 2:36 am
Stefan Krzywicki (9/10/2014)
TomThomson (9/10/2014)
Stefan Krzywicki (9/10/2014)
Date columns as a varchar(7). What are you even putting in there? Still better than the date columns as Timestamp I guess.
It's probably the ISO-8061...
September 10, 2014 at 11:36 am
Stefan Krzywicki (9/10/2014)
Date columns as a varchar(7). What are you even putting in there? Still better than the date columns as Timestamp I guess.
It's probably the ISO-8061 presentation format for...
September 10, 2014 at 11:12 am
Alan.B (9/10/2014)
MDS and DQS also rely heavily on CLR - those are not going away anytime soon.
Some time in the 90s someone probably said "ODS relies heavily on extended stored...
September 10, 2014 at 11:06 am
Steve Jones - SSC Editor (9/10/2014)
Jeff Moden (9/10/2014)
Solomon Rutzky (9/9/2014)
In the end, isn't this why Microsoft gave us CLR Integration?
Heh... yeah... just like they gave us the ability to write...
September 10, 2014 at 10:57 am
Luis Cazares (9/9/2014)
with number as (select Exam_id
, row_number() over (partition by exam_id order by...
September 9, 2014 at 5:45 pm
Here's a fairly primitive way to do it. Possibly not brilliant performance, but if you are only going to run it once....
First, some code to create the source and...
September 8, 2014 at 3:19 pm
Interesting question.
But as Erikur pointed out, the correct answer is "It depends" (on your default schema) and is not available. :hehe:
September 8, 2014 at 10:39 am
The DBAs to be scared of are the ones who can't reliably do their jobs. They are just as likely to have trained as DBAs as to be accidental...
September 8, 2014 at 10:23 am
djj (9/8/2014)
Ed Wagner (9/8/2014)
ChrisM@Work (9/8/2014)
Ed Wagner (9/8/2014)
crookj (9/8/2014)
Ed Wagner (9/7/2014)
TomThomson (9/5/2014)
Ed Wagner (9/5/2014)
Sean Lange (9/5/2014)
CapsizeExpensive
Dear
Yes, Dear
Honey-Do
Perpetual
Peripatus
Worm
Fishing
Flies
September 8, 2014 at 9:16 am
CELKO (9/6/2014)
September 7, 2014 at 8:10 am
It depends what you want to do with the NULLs. You can either turn them into zero length strings, or just throw them away. Or you may wnt...
September 6, 2014 at 11:51 am
In the stored procedure you generate the string SELECT * from Employee where EmployeeName LIKE '%????%'
What you need is the stringSELECT * from Employee where EmployeeName LIKE N'%????%'
So you need...
September 6, 2014 at 11:01 am
Grant Fritchey (9/5/2014)
September 5, 2014 at 6:02 pm
CELKO (9/5/2014)
Why do we want names here? I can see no point to them.
To help preserve atomicity, of course. 😛
Clearly then you haven't read this passage:-
E.F.Codd (1990)
From a database...
September 5, 2014 at 5:49 pm
Viewing 15 posts - 2,221 through 2,235 (of 7,484 total)