Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,621 through 19,635 (of 59,072 total)

RE: Find string with spaces and replace them with other string

shamshad.ali (9/8/2015)
I have following query which return me SP/Views and Functions script using:
select DEFINITION FROM .SYS.SQL_MODULES
Now, the result looks like
Create proc
create procedure
create proc
create ...
--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 8, 2015 at 6:15 am

#1825083
RE: Need help on excel file generation through backend

Kind of. As you've found out, BCP is not actually capable of exporting "Excel" files. It's only capable of exporting text (and data formatted specifically for SQL 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 8, 2015 at 5:44 am

#1825078
RE: The Scientific Method

jhbelalc (9/8/2015)
Now, software works or not, yes that easy.
If that were only true.
--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 8, 2015 at 5:34 am

#1825076
RE: ISNULL vs IS NULL performance

"It Depends". By themselves, everything above is true. However, if you have sufficient other predicates against the table, you CAN still get index seeks from those predicates even...
--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 11:03 pm

#1825036
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

Viewing 15 posts - 19,621 through 19,635 (of 59,072 total)