Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,606 through 19,620 (of 59,098 total)

RE: CACHESTORE_SQLCP consuming all memory in an instance

TheSQLGuru (3/12/2015)
Please don't respond to 4-year old threads Steve. Thanks!
Why not? If someone has a solution to even a really old thread, why not post it? It's...
--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 14, 2015 at 11:59 am

#1826493
RE: Need Help in Recursive Query in SQL using CTE

So to summarize, given any DetailComponent, you want to return both the "upline" and the "downline" of that component?
How many rows will end up in this table and how often...
--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 14, 2015 at 9:26 am

#1826415
RE: Commercial Software with All Tables as Heaps and Terrible Performance

It's not Oracle. It's unaware front-end developers creating tables using Visual Studio. It's amazing what a poor job it does if you don't actually specify things explicitly.
--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 14, 2015 at 8:40 am

#1826384
RE: Optimisation of unpivot/insert code

Indexes probably won't help at all because you're looking at the whole table.
Thanks for the feedback on the true UNPIVOT method. I'll give that a try, as well.
--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 14, 2015 at 8:02 am

#1826369
RE: Commercial Software with All Tables as Heaps and Terrible Performance

Eirikur Eiriksson (9/13/2015)
Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees but X000% Annual interest rate:pinch:
😎
Jeff Moden (9/12/2015)
It's a really good...
--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 14, 2015 at 12:44 am

#1826282
RE: Optimisation of unpivot/insert code

Because it's still an estimate of cost, I don't trust even the Actual Execution Plan when trying to determine which code will be faster or use fewer resources. It's...
--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 13, 2015 at 9:52 am

#1826247
RE: convert rows to columns in query

Along with JLS's fine answer above, please see the following article to understand how it works.
http://www.sqlservercentral.com/articles/T-SQL/63681/
For your next post, please see the following article for the best way to post...
--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 13, 2015 at 8:22 am

#1826245
RE: Save query results directly using variables and date/time

Grant Fritchey (9/8/2015)
Jeff Moden (9/4/2015)
Grant Fritchey (9/2/2015)
I would focus on using PowerShell. You can make the call to the procedure, capture the output to file. It's the most direct mechanism...
--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 12, 2015 at 10:00 pm

#1826229
RE: SQL syntax help - this should be simple

mw112009 (9/8/2015)
cool
good job.
i am happy with the reply
Now... what did you learn?
--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 12, 2015 at 9:54 pm

#1826228
RE: Commercial Software with All Tables as Heaps and Terrible Performance

robinwilson (9/12/2015)
Hello
I recently moved to a new organisation and one of my first tasks was to work out why the main software the organisation uses is, and has always been,...
--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 12, 2015 at 9:37 pm

#1826227
RE: Percentage of Fragmentation increased after 6 hours

Kristen-173977 (9/11/2015)
Jeff Moden (9/11/2015)
What format is that column stored in?
I'm guessing again ... but a normal GPS message starts with a code (which might not change) immediately followed by 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 12, 2015 at 12:55 am

#1826192
RE: Percentage of Fragmentation increased after 6 hours

coolchaitu (9/11/2015)
You are correct. It refers to the index in the attached image. Its definition is as below:
INDEX = IX_tblGPSDataDetail_DeviceID_GPSDateTime ON dbo.tblGPSDataDetails
(
DeviceID {udt_DeviceID 4}
, GPSDateTime {varchar 50}
, DataReceviedDateTime {udt_date 8}
)
INCLUDE
(
...
--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 11, 2015 at 2:43 pm

#1826160
RE: "send me some of your code"

Alvin Ramard (9/10/2015)
Sometimes recruiters ask questions that seem weird, but are asked for a specific reason.
I know one recruiter that will ask a weird question during his first contact with...
--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 10, 2015 at 9:26 pm

#1825875
RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

@erichansen1836
It sounds to me like you already had your mind made up when you posted your question. If everything you're doing is FREE and you're happy with performance and...
--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 10, 2015 at 9:09 pm

#1825874
RE: Trigger fire on each inserted row to insert same record into remote Table

mohelsheikh (9/10/2015)
Thank you Jeff Moden
the problem is i don't have enough permission to create task or linked server. this why i am using this complicated way to save the record...
--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 10, 2015 at 8:56 pm

#1825873

Viewing 15 posts - 19,606 through 19,620 (of 59,098 total)