Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,601 through 27,615 (of 59,101 total)

RE: 10 physical disks available - best configuration for data/log/backup?

If each disk is 300GB, how is it that you're only getting 600GB out of 4 drives and 300GB out of 2 drives according to your description? Is...
--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)

January 30, 2013 at 6:25 am

#1582582
RE: The Knowledge Graph

BWAAAHAAA!!! "Driverless cars". We already have those where I live. The drivers are electric shaving or putting on lipstick while texting, trying to manage a bagel, doing...
--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)

January 29, 2013 at 10:36 pm

#1582468
RE: plz i need help!!!!

C.K.Shaiju (1/28/2013)
Correct. In the first post he wants NULL and 2nd post 0 or Nothing (NULL). Thought he might be doing something with NULL. That's why I posted that script...
--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)

January 29, 2013 at 10:16 pm

#1582465
RE: SQL SERVER CPU Usage 100 % even at no traffic time

Bhuvnesh (1/28/2013)
purushottam2 (1/28/2013)
Once user start accessing application then only it lead to 100% cpu consumption.
then sql profiler trace might help you , set the trace and try...
--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)

January 29, 2013 at 10:12 pm

#1582464
RE: Import Excel using OPENROWSET only works for SA

I just had a great thought on this, ST... it's a nice short subject so you could go either way on it. You should write a short "SQL Spackle"...
--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)

January 29, 2013 at 9:57 pm

#1582460
RE: Import Excel using OPENROWSET only works for SA

Crud. I completely forgot about such a thing. The last time that happened to me it was back when it all went to C:\Temp.
Obviously, there is...
--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)

January 29, 2013 at 9:52 pm

#1582459
RE: Antipathy for Entity Attribute Value data models

long_shanks64 (1/23/2013)
BillyJack
Q. Who implements the restrictions as to which business functions and 3rd parties have access and update permissions to this new attribute. Who decides how this new attribute will...
--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)

January 28, 2013 at 8:59 pm

#1581878
RE: Antipathy for Entity Attribute Value data models

lnardozi 61862 (1/28/2013)
I wouldn't want to change the table structure every time a requirement changes.
The DBA has better things to do, and many DBAs are not noted for their SQL...
--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)

January 28, 2013 at 8:28 pm

#1581873
RE: Create string using input values

dwain.c (1/28/2013)
Jeff Moden (1/28/2013)
Just say "NO" to the mind drug known as "loops" in T-SQL. 😉
I do!! 😀
😀
--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)

January 28, 2013 at 7:51 pm

#1581868
RE: Computed column with/with out PERSISTED

ScottPletcher (1/28/2013)
Jeff Moden (1/28/2013)
My personal opinion is that if you're not going to persist a calculated column, write a derived table or view, instead. That way, no one 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)

January 28, 2013 at 5:06 pm

#1581854
RE: Create string using input values

Steven Willis (1/28/2013)
OK, OK, I surrender. But for creating sample data I see no reason not to use a loop--it's quick even if dirty. I was playing around and spent...
--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)

January 28, 2013 at 5:03 pm

#1581853
RE: plz i need help!!!!

C.K.Shaiju (1/28/2013)
Yes Jeff,
I had that thing in my mind. But in the first post he wants "result with a null value". I should have post both the scripts 😀
Thanks...
--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)

January 28, 2013 at 4:45 pm

#1581848
RE: SQL SERVER CPU Usage 100 % even at no traffic time

purushottam2 (1/28/2013)
I have checked by Query, And also at time when our IIS server was stop CPU usage was 0 %, if we start IIS server and user accessing application...
--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)

January 28, 2013 at 4:41 pm

#1581846
RE: The Optimists

bryce.hill (1/25/2013)
It is painfull to make changes because you use SQL Server. It is a shite product that should never be used by a real company and not real companies...
--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)

January 28, 2013 at 4:39 pm

#1581845
RE: SQL SERVER CPU Usage 100 % even at no traffic time

purushottam2 (1/28/2013)
it is charging few dollars, i have to take approvals from client.
You're seriously suggesting that it's not worth it for you to invest a few bucks in your own...
--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)

January 28, 2013 at 4:36 pm

#1581844

Viewing 15 posts - 27,601 through 27,615 (of 59,101 total)