Viewing 15 posts - 226 through 240 (of 476 total)
Longshot: CDC enabled on MSDB database?
September 27, 2015 at 4:24 am
Grant Fritchey (9/24/2015)
I'm not sure I'd bother taking so many differentials. Instead, make sure you have log backups in place to be able to restore to a point in time.
We...
September 27, 2015 at 4:17 am
-- /*
... Live code that optionally needs disabling ...
-- */
is interesting, thanks. I saw that style for the first time just the other day on some sample code in a...
September 27, 2015 at 4:09 am
Thanks all, not what I wanted to hear! Magic Bullet would have been much more palatable 🙂
Some of our functions (like "round date to midnight") are probably only used to...
September 27, 2015 at 3:47 am
Michael L John (9/26/2015)
It will return successful if it can be converted to ANY numeric type. Try an int, numeric(12, 3(or4)) or float. One of them will work!
Thanks,...
September 27, 2015 at 3:33 am
robinwilson (9/26/2015)
I think you are going to have that problem with all of them (except perhaps sp_HelpText) due to column-width display limits in SSMS -...
September 27, 2015 at 3:11 am
David.Poole (9/26/2015)
In the event of wanting to query the logs why not agree an SLA preferably one that doesn't set the expectation of instant access.
Because in the example I gave...
September 27, 2015 at 2:57 am
I changed your code to allow multiple runs and the output of aggregated average.
I don't know if the changes I have made are "safe" in terms of timing and Statistics...
September 26, 2015 at 5:07 am
Eirikur Eiriksson (9/26/2015)
Quick demonstrationTest harness
That's really helpful, thanks.
I've been glibly assuming that scalar functions, returning a single value (rather than table), would be equivalent to doing the calculation inline. I...
September 26, 2015 at 4:55 am
WayneS (9/25/2015)
And it doesn't take a period one of those names to mess this up... just a space would do it also.
Very entertaining video of a presentation by Rob Volk...
September 26, 2015 at 1:54 am
Probably useless as a suggestion, but could you add logging to the SProcs which stored SProc name, Table name, and Date started / finished?
September 26, 2015 at 1:47 am
Michael L John (9/25/2015)
IsNumeric does not look for numbers, it returns 1 if a value can be successfully be CONVERTED or CAST to a numeric data type.
Not sure about "successfully"??...
September 26, 2015 at 1:45 am
robinwilson (9/25/2015)
September 26, 2015 at 1:39 am
GilaMonster (9/24/2015)
Kristen-173977 (9/23/2015)
GilaMonster (9/23/2015)
September 26, 2015 at 1:36 am
Presumably reading the SQL Error Log to find the failed logins is completely unrealistic in practice? (i.e. using xp_readerrorlog and having turned on Failed Login auditing for the instance)
P.S. I...
September 26, 2015 at 12:47 am
Viewing 15 posts - 226 through 240 (of 476 total)