Viewing 15 posts - 19,561 through 19,575 (of 59,072 total)
Sean Lange (9/17/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 17, 2015 at 8:29 am
Man o' man... guess I need to find out what the hell's the matter with my Dev box at work. Here are the run results of Lynn's code from...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 17, 2015 at 8:14 am
Sean Lange (9/16/2015)
drew.allen (9/16/2015)
Try the FORMAT function. It was added in SQL 2012.
SELECT FORMAT(vhrgdt, '0000-00-00') + ' ' + FORMAT(vhrgtm, '00:00:00.000'), *
FROM #Something s
Drew
Thanks Drew. I don't use FORMAT very...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2015 at 10:57 pm
I've always thought this whole process was a bit, um... well... stupid. If you're not happy with your job, etc, yadda, yadda, then you should be talking about it...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2015 at 10:45 pm
Perry Whittle (9/16/2015)
Jeff Moden (9/15/2015)
5. Are you allowed to use xp_CmdShell (which would make this easy)?Powershell is even easier 😉
I'll have to try it someday. 😉 Can it...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2015 at 7:37 am
I haven't done a deep dive on the article but it looks good. The Get-SQLBackups function is nice, clean, and easy to read. It'll be a big help...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2015 at 6:57 am
ramana3327 (9/15/2015)
I am working with one of the task automating the db refresh in test server from production backup.
I need your expertise advice
The production backup sits on the production server...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 6:52 pm
sqlinterset (9/15/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 4:42 pm
Also, the following comparison should be >= instead of just >.
where ml.processingstarted > '2015-09-08'
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 4:37 pm
Alvin Ramard (9/15/2015)
One question on Ask SQL Server Central is just begging for a smart *** answer!Question: Difference between 32 bit and 64 bit?
Answer: 32 bits.
😀
That and the shift to...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 4:34 pm
J Livingston SQL (9/15/2015)
erichansen1836 (9/10/2015)
If you implement a Network database file system of 500 MDB files, each acting as a partial table within the 5 billion row database, each MDB...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 3:24 pm
Heh... remind me not to even attempt such questions in the future. I mentally added "and do it right" to the question which, of course, would have led me...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 11:08 am
erichansen1836 (9/15/2015)
SQL SERVER
========
* For Network or non-Network Databases larger than 5 Terabytes and 25 Billion rows - use SQL Server
* For Network Databases smaller than 5 Terabytes and...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 10:45 am
vedau (9/15/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 8:20 am
Markus (9/11/2015)
try backing up to multiple files... 3...4... instead of 1 file.
Also, if you are SQL2008R2 or greater use the COMPRESS...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 15, 2015 at 8:18 am
Viewing 15 posts - 19,561 through 19,575 (of 59,072 total)