Viewing 15 posts - 5,791 through 5,805 (of 8,416 total)
:w00t: :smooooth: :w00t: :smooooth: :w00t: :smooooth: :w00t: :smooooth: :w00t:
------------------------------
Sequence Table article finished!
------------------------------
:w00t: :smooooth: :w00t: :smooooth: :w00t: :smooooth: :w00t: :smooooth: :w00t:
I've sent a copy by mail to those that expressed an...
February 27, 2010 at 9:59 pm
RBarryYoung (2/27/2010)
Secondly, I am a little confused, is there a good form of this query or only a bad form?
That was based on Jeff's code I think. The...
February 27, 2010 at 9:54 pm
Jeff Moden (2/27/2010)
Did you ever send that to me or did I just miss it somewhere in the daily flood of email?
Barry distracted me with his interesting solution to Itzik's...
February 27, 2010 at 7:39 pm
wschampheleer (2/27/2010)
Easier to write and maintain.
Seriously? That hasn't really been my experience. CASE statements are a great way to avoid using a useful index, of course 😛
February 27, 2010 at 7:37 pm
Jeff Moden (2/27/2010)
Cool... what kind of information did the table hold where it exceeded the positive values of INT?
Well this was 13 years ago...but to the best of my recollection,...
February 27, 2010 at 7:35 pm
Welsh Corgi (2/27/2010)
I did not mean to get personal or offend anyone.
Well you did, but I for one won't hold it against you. Let's move on.
Welsh Corgi (2/27/2010)
February 27, 2010 at 7:29 pm
lmu92 (2/27/2010)
If number of columns and data type would be identical for table 1 and table2 I guess Pauls approach would be the way to go.
No, it's a daft idea....
February 27, 2010 at 7:26 pm
agustingarzon (2/26/2010)
February 27, 2010 at 7:17 pm
Jeff Moden (2/27/2010)
nathan 7372 (2/27/2010)
February 27, 2010 at 6:55 pm
Jeff Moden (2/27/2010)
Paul White (2/27/2010)
Turns out all that is needed to get rid of the index spool is to define the clustered index as UNIQUE. Given that information, a...
February 27, 2010 at 6:54 pm
lmu92 (2/27/2010)
Which one out of the three solutions would you actually use on the given scenario (extended volume)?
I'm not sure if the execution plan shows real figures on...
February 27, 2010 at 6:51 pm
SELECT name = node.value('./@name', 'VARCHAR(30)'),
account = node.value('./@account', 'INTEGER'),
flag = node.value('./@flag', 'BIT')
FROM ...
February 27, 2010 at 8:32 am
Divya Agrawal (2/26/2010)
I have written a post on DATEFIRT which can help you understand the usage of it..
LOL 😀
February 27, 2010 at 7:23 am
EnigmaticSoul (2/25/2010)
TI think I found a much easier way to tackle the problem, though:
CAST (o.[data] AS XML).value ('declare default element namespace "urn:schemas-quest-com:ActiveRolesServer"; (/Operation/Initiator/@dn)[1]', 'nvarchar(255)') AS xmlChangeHistory
Not as easy as using...
February 27, 2010 at 7:22 am
wschampheleer (2/23/2010)
February 27, 2010 at 7:15 am
Viewing 15 posts - 5,791 through 5,805 (of 8,416 total)