Thanks Jeff for your reply.

query is not returning all data , its just returning row count .

I assume that the query should return the row count quickly , not...

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, 8 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

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...

Better than that, download and install the Developer's Edition of SQL...

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...

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...

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...

Ah... I understand, now.  I'll be back.

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, 8 months ago by Jeff Moden.

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...

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,...

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...

You should ask Ola. 😉  He wrote it.

What is the "Buddy Program"?  Sharing a hotel room?

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...