Viewing 15 posts - 2,026 through 2,040 (of 6,036 total)
I think you need to stop converting the source data to an excel-like pivot table and do your calculations inline.
It will make things much simpler.
Unfortunately, you did not provide a...
April 9, 2013 at 7:43 pm
quackhandle1975 (4/9/2013)
I should have been clearer, I was not saying avoid triggers.
Yes, this one looks very different. 🙂
They say - consider environment. Look at the name of the article you're...
April 9, 2013 at 3:55 pm
Whatever clever function you may find/create the phrase
'US Eastern District Court'
will still be matching
'US Western District Court'
better than
'United States Eastern District Court'
It's a lot of general knowledge...
April 8, 2013 at 11:58 pm
This should help a bit:
Add to table OfferOverlaps:
,
constraint uk_OfferOverlaps unique (OverlappingOfferID,OfferID)
and this to table OrderItems:
CREATE INDEX IX_ItemOrder ON OfferItems(ItemID, OfferID)
And to avoid DISTINCT you may use...
April 8, 2013 at 11:47 pm
rocky_498 (4/8/2013)
I have two questions.
1) My first question, how i can find out on which table of my database has dead lock problem?
2) If i...
April 8, 2013 at 11:11 pm
opc.three (4/8/2013)
April 8, 2013 at 10:39 pm
Jeff Moden (3/27/2013)
April 8, 2013 at 10:32 pm
opc.three (3/26/2013)
This from a guy that argues about the optimizer with Paul White...get a clue troll.
Who is Paul White?
The bearer of the ultimate knowledge?
Your local shiny little god?
...
April 8, 2013 at 10:08 pm
opc.three (3/26/2013)
I absolutely do recommend alternatives to xp_cmdshell, namely PowerShell, SSIS, .NET, anything but xp_cmdshell.
I'm desperately want to know what kind of damage to the system can be done with...
April 8, 2013 at 9:30 pm
quackhandle1975 (4/8/2013)
Odd reply, Sergiy. My comment was aimed at beginners and programmers who find themselves coding t-sql.
I reread your comment 5 times more - it does not say anything...
April 8, 2013 at 4:05 pm
quackhandle1975 (4/5/2013)
I have seen Cursors in triggers bring systems to a complete halt (I know as I had to debug it!). Best avoided IMHO.
I've seen 7 peple killed in a...
April 8, 2013 at 4:41 am
opc.three (3/26/2013)
Sergiy (3/26/2013)
He was not referring to sp_configure at all.
Oh, really?
What was that about then?
http://www.galileowaswrong.com/galileowaswrong
You're a clown, that's funny 😛
It's sad you don't even realise how pathetic you are...
:ermm:
March 26, 2013 at 8:49 pm
opc.three (3/26/2013)
- page 153 recommends to "disable xp_cmdshell"
- page 161 recommends "removing the extended stored proc xp_cmdshell" but goes on to say that (paraphrased) "you...
March 26, 2013 at 7:53 pm
mister.magoo (3/26/2013)
How do we all feel about SQL Agent Jobs and the ability to run operating system commands from them?
I personally feel very well.
Especially about those ones which delete themselves...
March 26, 2013 at 7:28 pm
Michael L John (3/26/2013)
How about an article about securing SQL server?
You mean - a book?
:hehe:
I guess for an article it would be enough to stay within "SQL Server - OS...
March 26, 2013 at 7:20 pm
Viewing 15 posts - 2,026 through 2,040 (of 6,036 total)