Viewing 15 posts - 466 through 480 (of 5,685 total)
ShinyBaldHead (2/3/2014)
February 3, 2014 at 12:23 pm
Agreed. There's just too many variables. Example: I personally only usually use views to consolidate a standard approach to get a particular component of data in an optimal...
January 31, 2014 at 1:49 pm
ps_vbdev (1/31/2014)
Whats the best way to get a nightly copy my source database onto my staging server.
My personal preference is to restore the production copy's backup. This gives you...
January 31, 2014 at 1:47 pm
That's a really strange set of errors and troubleshooting results. I'm half posting just so you have a response on this and don't think you're being ignored. Personally,...
January 31, 2014 at 1:44 pm
ShinyBaldHead (1/31/2014)
January 31, 2014 at 1:37 pm
I'm thinking your proc is reporting an error to the engine, and the engine is losing it, not necessarily that your proc is losing it.
January 30, 2014 at 2:08 pm
It may be an unhandled error so it's failing silently.
I'd start with a trace of the process so you can see exactly what the rules engine is providing to the...
January 30, 2014 at 1:52 pm
polkadot (1/30/2014)
January 30, 2014 at 1:23 pm
polkadot (1/29/2014)
January 29, 2014 at 5:47 pm
sneumersky (1/29/2014)
HASHBYTES is the best for determining total and complete uniqueness if you are willing to deal with the overhead.
From MSDN:
Return Value
--------------------------------------------------------------------------------
varbinary (maximum 8000 bytes)
If I'm going to possibly compare...
January 29, 2014 at 4:09 pm
This usually happens not because of your delimeter, but because the source metadata is assuming x length, and your target is x-n, so the concatonation throws up warnings.
The best way...
January 29, 2014 at 4:07 pm
Bruce W Cassidy (1/29/2014)
January 29, 2014 at 1:19 pm
I've done this before, also with the Persisted computed column for only relevant fields, though I usually use a key-checksum combination.
What I typically do is load the key/checksum combination into...
January 29, 2014 at 12:47 pm
Excellent article, thanks Magoo.
January 28, 2014 at 5:42 pm
dwain.c (1/28/2014)
That user alone would generate POWER(2,32)-1 rows (working from memory here so check the article to be sure). That's a lot of rows.
Amusingly:
select power(2 ,32)
Msg 232, Level...
January 28, 2014 at 5:27 pm
Viewing 15 posts - 466 through 480 (of 5,685 total)