Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,651 through 19,665 (of 59,098 total)

RE: The Scientific Method

Oooooo.... don't get me started... especially about some of the idiotic test methods and totally ridiculous conclusions that their faulty testing leads them to. Unfortunately, some of the folks...
--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 7, 2015 at 10:58 pm

#1825035
RE: parent records ordering and display child records next to it

ramrajan (9/7/2015)
declare @table table (
ParentID INT,
ChildID INT,
Value float
)
INSERT INTO @table
SELECT 1,1,1.2
union
select null,1,4.8
union
select null,1,4.6
union
select 2,2,1.8
union
select null,2,1.4
union
select 3,3,1.12
union
select null, 3 , 56.7
union
select null,3,43.6
select * from @table
/*
This case ParentID - Child...
--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 7, 2015 at 3:38 pm

#1825025
RE: SQL Script Generate

Thanks, Jayanth.
--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 7, 2015 at 12:09 pm

#1825014
RE: Percentage of Fragmentation increased after 6 hours

You're welcome and thank you for the kind feedback.
--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 7, 2015 at 8:59 am

#1824998
RE: Require help on starting for OLAP

sqlinterset (8/31/2015)
Currently i am using sql queries to show data in excel pivot tables. however, data is very large around in millions and take so much time in refreshing 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 7, 2015 at 8:56 am

#1824997
RE: Agent job query help

Google sysjobhistory (found in the MSDB database). It contains things like a "run_duration" column (although you need to get used to the idea of such things being store in...
--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 7, 2015 at 8:35 am

#1824992
RE: Application Development for SQL Server

jacksonandrew321 (9/6/2015)
I am working with SQL Server 2012, I am skilled in SSIS and SSRS, I need to start developing applications for editing data in SQL Server to give users...
--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 7, 2015 at 8:06 am

#1824987
RE: SQL Script Generate

Minnu (9/7/2015)
Hi Team,
I have a list of 100+ tables in my SQL Database with most of the columns are declared as VARCHAR, I want to create the same 100+ tables...
--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 7, 2015 at 7:48 am

#1824980
RE: Percentage of Fragmentation increased after 6 hours

coolchaitu (9/7/2015)
Dear Jeff sir,
Thanks for contributing and helping beginner level people like me. Should the scans be lesser than seeks?
Actually, I did not understand the below statement:
" If the problem...
--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 7, 2015 at 7:16 am

#1824963
RE: Require help on starting for OLAP

sqlinterset (9/2/2015)
Currently data is fetched from SQL server through queries
You should post the one that takes the longest along with the information identified in article at the second helpful 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 6, 2015 at 8:56 pm

#1824892
RE: Agent job query help

vsamantha35 (9/6/2015)
Hi All,
Looking for help in tsql query to pull out SQL Agent job list that are executing more than normal. For instance, if job is expected to run...
--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 6, 2015 at 8:52 pm

#1824891
RE: Mount Points

SQL-DBA-01 (9/3/2015)
I write PS query to get the details.
Cool. Please share 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 6, 2015 at 8:48 pm

#1824890
RE: SQL Performance Elevenses

Keithyv (8/31/2015)
Number one should be '...affecting..' not '..effecting..'
The above should have '...effecting...' not '..effecting..'. 😉
--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 6, 2015 at 10:59 am

#1824878
RE: Select statement that needs to use custom grouping

If this is in the design phase, then anticipate the worst and that would be them adding another level to the mix. Don't say it won't happen because 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)

September 6, 2015 at 10:53 am

#1824877
RE: logging without blocking?

I do such logging from within stored procedures all the time. The key is to NOT include the logging inside an explicit transaction.
I'll also state that having "long running...
--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 6, 2015 at 10:45 am

#1824876

Viewing 15 posts - 19,651 through 19,665 (of 59,098 total)