Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,746 through 8,760 (of 59,099 total)

Reply To: Select count(*) from table1 is taking time

aprathour.89 wrote:
Hi All,
Select count(*) from table1 is taking around 5 mins.
table is having 4035938 rows.
can anyone suggest what may cause row count to slow and how it can be optimized...
--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 1, 2019 at 12:35 am

#3676100
Reply To: SSIS Package Crashing

According to the following link...
https://docs.microsoft.com/en-us/windows/win32/winhttp/error-messages
... the WinHttp error of 12007 means that "The server name cannot be resolved.". Does the server or user actually have privs to where 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 1, 2019 at 12:32 am

#3676099
Reply To: Merge Columns when Column in Master-/PK-Row is NULL

My take on this would be to find and fix the code that's making this mess and then make the ORDER TYPE column NOT NULL. Actually, the best thing 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)

September 1, 2019 at 12:21 am

#3676097
Reply To: SQL Query between 2 dates

Ah... I understand, now. I'll be back.
--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)

August 31, 2019 at 8:14 pm

#3676084
Reply To: Index and fragmentation
Ah... almost forgot...
The word "Data" is a bit misleading and can be used in many ways based on the esoteric subject. It's a bit like using the word "flower", which...
- This reply was modified 7 years, 1 months ago by Jeff Moden.
--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)
August 31, 2019 at 7:59 pm

#3676080
Reply To: Index and fragmentation

anoop.mig29 wrote:
Thanks Jeff and Matt for replies and link
But it still doesnt ans my query.If Index are on disk physical structure as last link says so then why does various...
--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)

August 31, 2019 at 7:28 pm

#3676076
Reply To: Always Check on the Basics

Great article, Steve. And, yes, I agree... the basics will never go away and there will never be enough people that know them. Heh... as I've stated in the past,...
--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)

August 31, 2019 at 3:35 am

#3675971
Reply To: Upgrade SQL Server and Resource need

Admingod wrote:
We are planing to upgrade SQL Server from 2014 to SQL 2017, So based on current utilization of SQL Server the CPU usage is never exceeded more 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)

August 31, 2019 at 3:28 am

#3675970
Reply To: Always on and Ola Hallengren SQL Agent Jobs.

You should ask Ola. 😉 He wrote 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)

August 31, 2019 at 3:23 am

#3675969
Reply To: PASS Summit

What is the "Buddy Program"? Sharing a hotel room?
--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)

August 31, 2019 at 3:22 am

#3675968
Reply To: SQL Query between 2 dates

dataprotec wrote:
Hello
I'm working on programm for presence control
e.g
ID -      CheckIn                       - CheckOut
1     29/08/2019 10:00  --   29/08/2019 14:00
2     29/08/2019 22:00 --   30/08/2019 06:00
3     30/08/2019 10:00   --  30/08/2019 14:00
If i do a query...
--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)

August 31, 2019 at 3:21 am

#3675967
Reply To: Memories of DR testing

Really good article that covered a whole lot. The high point is how managers want everything but don't want to pay anything. I also believe that capital expenditures shouldn't be...
--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)

August 31, 2019 at 3:16 am

#3675966
Reply To: Reset the total to zero when ItemCount is >= 6

jcelko212 32090 wrote:
Did you know that a table must have a key by definition? It is not an option!
Actually, it IS an option. HEAPs work just fine for things like Audit...
--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)

August 31, 2019 at 2:51 am

#3675963
Reply To: Reset the total to zero when ItemCount is >= 6

jcelko212 32090 wrote:
>> I want to have a sum of the item count reset to 0 when the sum >= 6. <<
Did you know that a table must have a key...
--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)

August 31, 2019 at 2:32 am

#3675962
Reply To: Error with IDENTITY property on primary key column

jcelko212 32090 wrote:
my guess is that your table should look something like this:
CREATE TABLE Personnel
(employee_id CHAR(5) NOT NULL PRIMARY KEY,
employee_type CHAR(1) NOT NULL
CHECK (employee_type IN (???),,
employee_name VARCHAR(30) NOT NULL);...
--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)

August 31, 2019 at 2:24 am

#3675957

Viewing 15 posts - 8,746 through 8,760 (of 59,099 total)