Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,861 through 25,875 (of 59,099 total)

RE: Are the posted questions getting worse?

Shifting gears... now I finally realize how easy it is to start a war over something with a trivial meaning in one language and a substantial meaning in another.
http://www.nbcnews.com/business/lost-translation-coke-apologizes-offensive-bottlecap-4B11233764
--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 23, 2013 at 3:45 pm

#1652497
RE: Automate Your Backup and Restore Tasks

Kurt W. Zimmerman (9/23/2013)
Finally, it appears there is an on going battle to determine where to develop utility type tools to manage SQL Server. I, for one, prefer doing everything...
--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 23, 2013 at 8:38 am

#1652372
RE: TempDB best practices - Doubt

LOVER OF SQL (9/23/2013)
" If you have 4 processors, you could start 4 MDF" (in the case, i'll have 5 datafiles all right? (4 for ndf) and (1 mdf-default), ok?
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 23, 2013 at 8:34 am

#1652368
RE: SSRS report with dynamic column headers

akhileshguha05 (9/23/2013)
Hi,
as per your discription u 'r requirement is like when ever Row data changed column name also has to be changed. IF my understanding is correct u have 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 23, 2013 at 8:30 am

#1652364
RE: Automate Your Backup and Restore Tasks

dano2k3 (9/22/2013)
Seems if you are gonna use script, why not powershell?
Possibly because of the following...
dtodd 43553 (9/20/2013)
Hi,
The only reason why i think tsql is better is if you work with...
--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 23, 2013 at 8:25 am

#1652359
RE: Automate Your Backup and Restore Tasks

2Tall (9/20/2013)
Hi to all. It's been a while since I did this! 🙂
I now use T-SQL scripts in 3 steps. The reason for restoring daily is our planning team like...
--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 23, 2013 at 8:19 am

#1652357
RE: TempDB best practices - Doubt

LOVER OF SQL (9/23/2013)
1,000MB equals = 1GB? or 1MB?
and if I have 4 processor (physical) I need put more 3 datafile? because exist mdf (default).
You sad: "500MB with 500MB growth...
--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 23, 2013 at 8:04 am

#1652349
RE: Are the posted questions getting worse?

Grant Fritchey (9/23/2013)
Rolled out an explosive. It could be a lady finger or a nuclear bomb. Curious how it's going to go off. Stand by for a fizzle or 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 23, 2013 at 7:58 am

#1652347
RE: Build menu with CTE ....

hunchback (9/23/2013)
I changed [path] by order_val in the recursive part and now it should run flawless.
A recursive CTE is still an iterative approach so I do not hold my breath...
--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 23, 2013 at 7:56 am

#1652345
RE: Build menu with CTE ....

The "NM" stands for "Never Mind". I had posted a rebuttal saying that the code didn't sort alphabetically, which seemed logical to me at the time. Then I...
--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 23, 2013 at 7:51 am

#1652343
RE: screenshot on view

cs 29850 (9/22/2013)
Erland Sommarskog (9/22/2013)
I repeat what I said in my previous post:
Generally, when you ask this question like this, it helps if you post:
1) CREATE TABLE statements for your...
--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 22, 2013 at 11:39 pm

#1652240
RE: screenshot on view

Erland Sommarskog (9/22/2013)
Then again, if all you have is half hours for 24 hours, with no regards to date, all you need is something that generates the 48 half hours...
--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 22, 2013 at 11:36 pm

#1652239
RE: Search Using Stored Procedure

Probably the biggest thing wrong with it is that it's very prone to SQL Injection. Please see the following article for how to do "Catch All" queries without 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 22, 2013 at 11:23 pm

#1652238
RE: TempDB best practices - Doubt

LOVER OF SQL (9/22/2013)
yes, but the problem at the moment is because my tempdb is thin.... small.. (that is new project - SQL Server)... Hardware, OS, Database... and my tempdb...
--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 22, 2013 at 11:19 pm

#1652237
RE: TempDB best practices - Doubt

LOVER OF SQL (9/22/2013)
and about the size of them? how can i calculate that?
To be honest, I thought my post might inspire you to hit Google so that you can...
--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 22, 2013 at 5:38 pm

#1652225

Viewing 15 posts - 25,861 through 25,875 (of 59,099 total)