ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,346 through 6,360 (of 10,143 total)

RE: How do I get fragmentation levels for indexes...

jblovesthegym (5/1/2012)
...WITHOUT creating a sproc? Is there a Select I can run to get fragmentation levels for all indexes on a particular table/db/server?
SQL Server 2005 Diagnostic Information Queries
...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 1, 2012 at 6:54 am

#1481753
RE: Rebuild index is running a fragmentation query

aaron.reese (5/1/2012)
Guys,
I have a table with 48M rows in it which I had to copy from one database to another (same instance). to improve performance of the copy I...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 1, 2012 at 6:41 am

#1481742
RE: # of characters

Jeff Moden (5/1/2012)
For the same reason you'd distinct a column with dupes. To find out if there are dupes.
LOL! You got me 😛
I had an interview last friday morning....
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 1, 2012 at 5:10 am

#1481678
RE: # of characters

Jeff Moden (4/30/2012)
ChrisM@Work (4/30/2012)
dwain.c (4/30/2012)
ChrisM@Work (4/30/2012)
dwain.c (4/29/2012)
...Actually I like writing them because I figure the more I do the better I'll understand them. I did say it wouldn't perform...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 1, 2012 at 2:09 am

#1481626
RE: # of characters

dwain.c (4/30/2012)
ChrisM@Work (4/30/2012)
dwain.c (4/29/2012)
...Actually I like writing them because I figure the more I do the better I'll understand them. I did say it wouldn't perform as well (I...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 30, 2012 at 6:52 am

#1481204
RE: # of characters

dwain.c (4/29/2012)
...Actually I like writing them because I figure the more I do the better I'll understand them. I did say it wouldn't perform as well (I tested) but...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 30, 2012 at 4:21 am

#1481108
RE: Calculating time difference

Eugene Elutin (4/27/2012)
It's not, just this huge set of sum's and brackets on Friday did make me dizzy. Time for a pint!
😀
Careful with that axe, Eugene
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 27, 2012 at 7:55 am

#1480434
RE: Calculating time difference

Eugene Elutin (4/27/2012)
It's not, just this huge set of sum's and brackets on Friday did make me dizzy. Time for a pint!
😀
Stop that! It's two hours to Beer O'Clock!
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 27, 2012 at 7:54 am

#1480433
RE: find gaps in multiple sequences

Sample data:
CREATE TABLE #Sample (Doc_Nbr int,Ticket_Nbr int)
INSERT INTO #Sample
SELECT 12,907 UNION ALL
SELECT 12,908 UNION ALL
SELECT 12,909 UNION ALL
SELECT 12,913 UNION ALL
SELECT 12,915 UNION ALL
SELECT 12,919 UNION ALL
SELECT 14,1481 UNION...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 27, 2012 at 7:23 am

#1480390
RE: Calculating time difference

pwalter83 (4/27/2012)
ChrisM@Work (4/27/2012)
Oh come on, Paul - none of us is going to retype from a bitmap! Be nice!
This is a sample data from a stored procedure not a table....
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 27, 2012 at 6:08 am

#1480332
RE: Calculating time difference

Oh come on, Paul - none of us is going to retype from a bitmap! Be nice!
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 27, 2012 at 3:43 am

#1480255
RE: Calculating time difference

ChrisM@Work (4/26/2012)
Hi Paul
Can you post a little sample data please? I'm sure this can be done more efficiently.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 26, 2012 at 10:13 am

#1479884
RE: Calculating time difference

Cadavre (4/26/2012)
ChrisM@Work (4/26/2012)
Cadavre (4/26/2012)
...
The issue is that you're using formatted data in the database. Instead, you should store this as TIME or DATETIME then convert it to the correct format...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 26, 2012 at 7:04 am

#1479674
RE: Calculating time difference

Cadavre (4/26/2012)
...
The issue is that you're using formatted data in the database. Instead, you should store this as TIME or DATETIME then convert it to the correct format at the...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 26, 2012 at 6:51 am

#1479654
RE: Calculating time difference

Hi Paul
Can you post a little sample data please? I'm sure this can be done more efficiently.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 26, 2012 at 6:42 am

#1479641

Viewing 15 posts - 6,346 through 6,360 (of 10,143 total)