Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,096 through 19,110 (of 59,098 total)

RE: Query processor could not produce a query plan because of the hints defined in this query.

You are missing the word WITH on the second nolock.
--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)

November 30, 2015 at 11:51 am

#1842970
RE: Help Needed in dynamic sql

KGJ-Dev (11/29/2015)
Hi Jeff,
Thanks for your reply and basically i am planning to create generic function which will take "table name","column name to makecomma separated" and "where condition" and send...
--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)

November 29, 2015 at 8:30 pm

#1842779
RE: Struggle of a developmnet dba

I'll also add that being both a Developer and a DBA sounds nice on paper but, as you're finding out, it can be a real bugger. I gave up...
--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)

November 29, 2015 at 2:28 pm

#1842765
RE: Index creation taking long

rameelster (11/22/2015)
In a test database server ,database changed to single user mode while creating non clustered index on primary key taking long time to complete. the table is 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)

November 29, 2015 at 1:36 pm

#1842762
RE: Best way to deploy 100+ sql files.

SQLisAwE5OmE (11/28/2015)
Hi Jeff,
I did not test the script yet, but i kind of got an idea...i need to enter the server name, db name and the path details.
In regards 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)

November 29, 2015 at 1:15 pm

#1842761
RE: Help Needed in dynamic sql

KGJ-Dev (11/29/2015)
Hi,
below is my sample query
declare @Query nvarchar(max)
DECLARE @Names VARCHAR(8000)
Declare @tablename nvarchar(50) = 'sample',@columnname nvarchar(50) = 'userid',@Condition nvarchar = 'name = test'
SET @Query = ' SELECT ' + @Names...
--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)

November 29, 2015 at 12:33 pm

#1842754
RE: how to convert recursive CTE's into normal sql queries

siddharthak024 (11/29/2015)
We have to rewrite this query into normal SQL queries without the CTE's.
Gosh... WHY? What's wrong with using a recursive CTE for what it was best designed 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)

November 29, 2015 at 12:29 pm

#1842753
RE: How to know if data is committed after an insert

dplaut 49149 (11/28/2015)
It is obvious from what I'm seeing that the next step does not have the data in the table just loaded.
What is it that you're seeing to make...
--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)

November 29, 2015 at 12:13 pm

#1842752
RE: Giving Thanks

Speaking of Giving Thanks... thanks to all you folks out there in the armed forces and on the streets as policemen. Sometimes you might ask yourself "What the hell...
--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)

November 29, 2015 at 10:19 am

#1842750
RE: RAM to each Instance

When you start talking about tera-bytes for an instance, I'd start thinking about a lot more memory than 64GB per node and I wouldn't think about splitting it up much....
--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)

November 28, 2015 at 1:10 pm

#1842727
RE: Best way to deploy 100+ sql files.

SQLisAwE5OmE (11/27/2015)
Thanks John for providing the script.
Do you understand how it works and how to control the execution order of the scripts using John's method?
--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)

November 28, 2015 at 12:42 pm

#1842726
RE: query fail after 727855 reads and 30005 duration

amrmnabil74 (11/27/2015)
Thanks patrickmcginnis59 10839
can you tel me how to trace "SQL:BatchCompleted"
and find the error details
coz i only got error code without details
Yes... transfer the code to SSMS, give it 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)

November 28, 2015 at 12:37 pm

#1842725
RE: How To Pivot Not Joined Tables

rootfixxxer (11/28/2015)
So my problem it's that the pivot function needs an aggregate function to work, but what i need it's the current field value...
In this case it could be anything,...
--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)

November 28, 2015 at 12:28 pm

#1842724
RE: This is why SQL Server Central Forums rock!

Absolutely awesome job, YB! Congratulations!
--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)

November 28, 2015 at 12:04 pm

#1842722
RE: Best way to deploy 100+ sql files.

Keep the files separate. It's an advantage that you'll realize later. Just make a batch file that executes the scripts in the order that you want them.
--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)

November 27, 2015 at 10:43 am

#1842664

Viewing 15 posts - 19,096 through 19,110 (of 59,098 total)