Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,716 through 8,730 (of 59,072 total)

Reply To: SQL Query between 2 dates
In that case, please post your query so that we can check it for performance issues for you and so we can also see if you've come up with a...
- This reply was modified 6 years, 10 months ago by Jeff Moden. Reason: Remove contractions (like we're) from the comments in the code because the forum software doesn't handle them correctly
--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 5:33 pm

#3676187
Reply To: corruption in database : what do next

Here's one of the best links on the subject by one of the smartest people I know on the subject. Don't do ANYTHING until you've read the whole article 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 1, 2019 at 2:42 am

#3676116
Reply To: Using SSMS or similar... without a server

Erland Sommarskog wrote:
No, that is not possible.
But you can download and install of Express Edition, which is free, to your laptop.
Better than that, download and install the Developer's Edition of SQL...
--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 1:22 am

#3676105
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 6 years, 10 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

Viewing 15 posts - 8,716 through 8,730 (of 59,072 total)