Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,591 through 19,605 (of 59,072 total)

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
RE: "send me some of your code"

pietlinden (9/10/2015)
John,
It's a recruiter, which makes me wonder, because the number of recruiters in this town that understand and can evaluate the "goodness" of T-SQL code is less than 5....
--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 10:36 am

#1825747
RE: Query is taking very long to execute

akash_singh (9/10/2015)
i am using group by to get distinct data.
That would also be a part of the problem. It would seem that you might have an accidental many-to-many join going...
--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:01 am

#1825705
RE: Query is taking very long to execute

Grant is spot on. Column names encapsulated in formulas and OR in the WHERE clause is likely the larger problem.
A part of the problem may be due to 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 10, 2015 at 8:58 am

#1825703
RE: Query is taking very long to execute

Please post your new code that uses the DelimitedSplit8K function and attach the actual execution plan, as Gail asked.
--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:24 am

#1825687
RE: Big Data Problems

I think the biggest problem that people have with the analysis of any size data is that they have some preconceived notion of what they want to see rather than...
--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:17 am

#1825682
RE: Cross Apply with parameterized function

jghali (9/9/2015)
anything else I should look at?
Yes... despite your misgivings, you can't fix a car that you can't touch never mind see. Ask for a copy of the actual...
--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 7:57 am

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

pietlinden (9/9/2015)
Just wondering what other people think about questions like:
"Can you send me samples of your code?"
Without a job description (even a title would suffice!), I'm not sure what they're...
--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 7:49 am

#1825665
RE: Creating 15000 partitions

What's up? Did you quit or did you get the answer that you think you want from somewhere else?
--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 9, 2015 at 11:14 pm

#1825584
RE: Need help with Retrieving Data

Sweetbee870 (9/9/2015)
Okay this is what I'm running:
Select FirstName, LastName, Title
from Employees
See attached the Results. I need know how to only retrieve records for "Sales Representatives"
Hope this is...
--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 9, 2015 at 11:08 pm

#1825583
RE: Introduction

Welcome.
--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 9, 2015 at 11:05 pm

#1825582
RE: Delete large number of records

ScottPletcher (9/9/2015)
Jeff Moden (9/9/2015)
It looks like someone may have followed the old idea of adding one index to each column that could ever be used in a WHERE clause 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 9, 2015 at 5:31 pm

#1825570

Viewing 15 posts - 19,591 through 19,605 (of 59,072 total)