Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,176 through 26,190 (of 59,102 total)

RE: how to view log files

If you mean how to view the content of what is normally the ".ldf" file, it normally takes some 3rd party software to view the logfile. There are some...
--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)

August 18, 2013 at 11:08 am

#1642502
RE: option other than looping

Sha_ (8/17/2013)
Thank you for your reply. I took a look at this article and, while useful for certain situations, I don't understand how it would apply to mine.
I need...
--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)

August 17, 2013 at 11:24 pm

#1642466
RE: Know the Modifier's Login

You would need a trigger and, probably, the ORIGINAL_LOGIN() function to capture the login of the person making the direct changes.
--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)

August 17, 2013 at 11:18 pm

#1642465
RE: Dynamic properties/attributes of the entity

I'm thinking that this is way too big a question for a forum.
So far as your point-in-time stuff goes, I believe you're headed in the right direction.
I think your biggest...
--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)

August 17, 2013 at 11:10 pm

#1642464
RE: Split data from one column into multiple colums

kapil_kk (8/17/2013)
Also read the article that Jeff has posted, it an excellent article...
Previously I used to use PIVOT but after reading Jeff's article I start using CROSS TAbS....
Thanks Jeff for...
--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)

August 17, 2013 at 10:08 pm

#1642462
RE: Script to montior ErrorLog every 1 hour

But I don't think this is correct way creating tables and dropping tables and selecting data twice
It's fine the way it is except for the drops at the end. ...
--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)

August 17, 2013 at 7:57 pm

#1642455
RE: MAXDOP query hint doesn't work- SQL 2008R2 Enterprise Edition

curious_sqldba (8/17/2013)
I have enforced MAXDOP on my query using hint, i have enforce it to 8 but when i look at the task manager i see all 16 cores being...
--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)

August 17, 2013 at 7:20 pm

#1642454
RE: Help on query

jethrow (8/17/2013)
Another option:
SELECTname, CASE
WHEN Mark1>Mark2 AND Mark1>Mark3 THEN 'Mark1'
WHEN Mark2>Mark3 THEN 'Mark2'
ELSE 'Mark3' END
FROMSample;
Welcome aboard!
--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)

August 17, 2013 at 7:16 pm

#1642453
RE: Help on query

TheSQLGuru (8/17/2013)
jethrow (8/17/2013)
Another option:
SELECTname, CASE
WHEN Mark1>Mark2 AND Mark1>Mark3 THEN 'Mark1'
WHEN Mark2>Mark3 THEN 'Mark2'
ELSE 'Mark3' END
FROMSample;
CASE: My favorite 4-letter TSQL word!! 😎
Especially in this "case". 😛
Just so...
--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)

August 17, 2013 at 7:15 pm

#1642451
RE: Very strange performance issue

curious_sqldba (8/16/2013)
I have a simple query, if i run that query from SSMS it takes about 10 mins and if i run the same query as a exec sql task...
--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)

August 17, 2013 at 7:09 pm

#1642450
RE: Should He Stay or Should He Go?

sgmunson (8/16/2013)
I hate to have to say it, but folks - this topic started almost 3 YEARS AGO !!! It's already had pretty much everything there's likely...
--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)

August 17, 2013 at 7:02 pm

#1642449
RE: Tempdb data file fills up very often

p.swathi4 (8/17/2013)
How to find the queries thats causing tempdb fill very often.
It's a fairly large subject so you need to ask your assistant DBA the question. In fact, you...
--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)

August 17, 2013 at 4:38 pm

#1642447
RE: Split data from one column into multiple colums

Please see the following article. Change SUM to MAX if you want to "pivot" character based data.
http://www.sqlservercentral.com/articles/T-SQL/63681/
If you prefer a coded answer to your problem, please see the first...
--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)

August 17, 2013 at 4:26 pm

#1642446
RE: Opinions and Votes

...but it takes participation and rational, reasonable debate, not childish exaggerated complaints and insults. We want to influence and convince, not upset and anger.
I'm thinking that needs to become...
--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)

August 17, 2013 at 3:30 pm

#1642441
RE: Script to montior ErrorLog every 1 hour

You can't just dump any query into @Query for this. The best thing to do would be to capture the data in a table and then query that table.
--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)

August 17, 2013 at 3:15 pm

#1642439

Viewing 15 posts - 26,176 through 26,190 (of 59,102 total)