Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,561 through 19,575 (of 59,072 total)

RE: Painful datetime conversion

Sean Lange (9/17/2015)
The table is small right now because the system is not yet in production but it isn't likely to get too huge. Maybe 100 or so new rows...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 17, 2015 at 8:29 am

#1827436
RE: Painful datetime conversion

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 17, 2015 at 8:14 am

#1827430
RE: Painful datetime conversion

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 16, 2015 at 10:57 pm

#1827295
RE: The Counter Offer - Part 1

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 16, 2015 at 10:45 pm

#1827292
RE: Moving and restoring the db from latest backup -- Priority

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 16, 2015 at 7:37 am

#1827064
RE: PowerShell Tool Time: Controlling Our Tools

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 16, 2015 at 6:57 am

#1827046
RE: Moving and restoring the db from latest backup -- Priority

ramana3327 (9/15/2015)
Hi,
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 6:52 pm

#1826950
RE: String to Date without time-Sql server 2012

sqlinterset (9/15/2015)
I have string as '1-12-2012', i wanted to convert it into date as format '2012-12-01'. I used the function as cast('1-12-2012' as Date) it's working but for a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 4:42 pm

#1826921
RE: Speed Up Creating Temp Table

Also, the following comparison should be >= instead of just >.
where ml.processingstarted > '2015-09-08'
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 4:37 pm

#1826919
RE: Are the posted questions getting worse?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 4:34 pm

#1826916
RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 3:24 pm

#1826912
RE: The checksum

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 11:08 am

#1826832
RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

erichansen1836 (9/15/2015)
WHEN TO USE:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 10:45 am

#1826822
RE: Whats the approximate time to restore 570 GB Backup?

vedau (9/15/2015)
Make sure you have Instant File Initialization enabled too. It will not zeroing out the data file so the restore time will be much faster. Here is the link...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 8:20 am

#1826753
RE: Whats the approximate time to restore 570 GB Backup?

Markus (9/11/2015)
Not sure if this will help or not... worth trying..
try backing up to multiple files... 3...4... instead of 1 file.
Also, if you are SQL2008R2 or greater use the COMPRESS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 15, 2015 at 8:18 am

#1826752

Viewing 15 posts - 19,561 through 19,575 (of 59,072 total)