Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,591 through 19,605 (of 59,098 total)

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
RE: Speed up Setting Drill Through Parameters

With the understanding that I know little of SSIS, is there no way to do this auto-magically from some data somewhere based on some criteria?
--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:15 am

#1826751
RE: Commercial Software with All Tables as Heaps and Terrible Performance

robinwilson (9/14/2015)
I was going to say I'm sure that the software house will admit full responsibility for their shoddy work and give me a script to quickly create all the...
--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 7:08 am

#1826720
RE: Commercial Software with All Tables as Heaps and Terrible Performance

Eirikur Eiriksson (9/14/2015)
Someone has leaked the details
SPOM!!! 🙂
--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:49 am

#1826713
RE: JSON

sknox (9/11/2015)
Manic Star (9/10/2015)
Jeff Moden (9/9/2015)
Manic Star (9/9/2015)
JSON is evil incarnate. XML's bastard sibling at best.
😀
I LOVE IT! A kindred spirit!!!! 🙂
My first encounter with it was...
--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:44 am

#1826711

Viewing 15 posts - 19,591 through 19,605 (of 59,098 total)