Viewing 15 posts - 26,761 through 26,775 (of 59,102 total)
rburko (5/29/2013)
Jeff, I work with what I'm given. And I've probably covered all the possible swear words just thinking of the best way to handle what I'm given.
Heh... that's...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 30, 2013 at 6:48 am
lanky_doodle (5/29/2013)
Thanks guys.That's given me the starting point I need.
You have to be a little bit careful when it come to performance on such things, meaning that you should severely...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 29, 2013 at 4:12 pm
A "Functional DBA" is one that simply hasn't had too much of his own beer to drink. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
May 29, 2013 at 12:07 pm
This is a really bad idea. Just imagine all the 3 and 4 character swear words there are out there and that's just in the English language!
--Jeff Moden
Change is inevitable... Change for the better is not.
May 29, 2013 at 12:05 pm
Uwe Ricken (5/24/2013)
I'VE GOT IT!!!!!
A few minutes ago i got the mail from Bob - passed...
OMG - can't describe what I feel currently...
What a journey - it took me...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 29, 2013 at 11:36 am
The final step now would be to bounce the server to make sure that SQL Server actually does see the persisted mapping after a reboot. I'm pretty sure it...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 29, 2013 at 7:32 am
Use a named share and a UNC instead.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 2:03 pm
Please see the first link in my signature line for future posts. It will help you get coded answers much more quickly because people like to test their solutions...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 1:31 pm
keshava.murthy (5/28/2013)
The problem here is when the data spans to multiple years then it will sort as...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 1:28 pm
Don't do yet another character conversion for the sort. Also, you can simplify a lot... no need for separate calcs for year and month. You can sort by...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 1:26 pm
PearlJammer1 (5/28/2013)
The situation has happened because whenever we need to do a datacleanse the Dev's take a backup of the table and ...
As a bit of a sidebar, there's no...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 9:13 am
pnauta (5/28/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 8:38 am
Nice short script, Ravi. Thanks for posting it.
I guess my only concern is that the defaults for SSMS are to have both of these settings "ON". If a...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 7:37 am
sqlsurfing (5/26/2013)
The backups are no longer failing. They were failing due to lack of disk space and this has now been sorted, partly down to allocating more disk space, and...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 6:43 am
Thanks, Phil. Sounds like the near equivalent of using multiple CROSS APPLYs to do an unpivot with the same caveats. Good to know.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2013 at 6:40 am
Viewing 15 posts - 26,761 through 26,775 (of 59,102 total)