ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,546 through 7,560 (of 10,143 total)

RE: Help on Table/Query tuning

sudhanva (8/10/2010)
Hi,
I have a table with 3,000,000 records for one year. It has only a primary key.
Just select query without any where clause is taking 15-20min of time.
My question is,...
^{“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

August 10, 2010 at 7:42 am

#1204781
RE: Joining Multiple Tables - What is the correct order on JOINS?

This is worth a look.
^{“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

August 10, 2010 at 5:22 am

#1204657
RE: query help

khushbu (8/10/2010)
How do i write query that shows me data for one hospital.
My input looks like
hospital_nametable_namedatarid
00086Registratiejaar20071
00382Registratiejaar20082
Please provide table creation scripts and sample data as in the link below. Without this,...
^{“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

August 10, 2010 at 4:45 am

#1204621
RE: Are the posted questions getting worse?

Lynn Pettis (8/9/2010)
bitbucket-25253 (8/9/2010)
Celko is at it again
http://www.sqlservercentral.com/Forums/Topic965546-1292-1.aspx#bm966047
For a community which attempts to help, even the most inept, and helps so many this guy Celko is a real detriment .......
^{“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

August 10, 2010 at 2:37 am

#1204555
RE: Are the posted questions getting worse?

CirquedeSQLeil (8/9/2010)
Chris Morris-439714 (8/9/2010)
Brandie Tarvin (8/9/2010)
Is it wrong to cry when someone tells me they don't know what Bulk-Logged is?
http://www.sqlservercentral.com/Forums/Topic961511-146-2.aspx#bm966015
It's a forestry expression.
That is scary - check the timestamps of...
^{“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

August 9, 2010 at 10:19 am

#1204272
RE: Are the posted questions getting worse?

Brandie Tarvin (8/9/2010)
Is it wrong to cry when someone tells me they don't know what Bulk-Logged is?
http://www.sqlservercentral.com/Forums/Topic961511-146-2.aspx#bm966015
It's a forestry expression.
^{“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

August 9, 2010 at 10:16 am

#1204266
RE: Today's Random Word!

crookj (8/9/2010)
Chris Morris-439714 (8/9/2010)
Copper.
Valuable metal found in signal- and power-carrying cables. Train signalling, for instance. Sufficiently valuable to be cut and stolen in broad daylight on friday, in an area...
^{“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

August 9, 2010 at 8:12 am

#1204185
RE: Today's Random Word!

Copper.
Valuable metal found in signal- and power-carrying cables. Train signalling, for instance. Sufficiently valuable to be cut and stolen in broad daylight on friday, in an area just outside Reading,...
^{“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

August 9, 2010 at 7:05 am

#1204139
RE: Retrieving data from the same column

snehalata_d (8/9/2010)
Hello,
I have a table Orders
By applying sql query on it I am getting result set(table) as follows
sum(freight) | YEAR(orderdate)
-------------+------------------
----------- +------------------
25000 ...
^{“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

August 9, 2010 at 6:04 am

#1204092
RE: generate insert statements with data

vijay.s (8/9/2010)
A sp is made for that purpose. You can download it from
http://www.vyaskn.tripod.com/code.htm
Regards
Vijay
The link doesn't work.
^{“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

August 9, 2010 at 5:31 am

#1204077
RE: UPDATE DateTime - how do I do it?

karin.askeroth (8/9/2010)
I'm beginning to think I'm in the wrong forum, maybe this isn't a place for any questions concerning how to use sql? I don't think it matters which programs...
^{“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

August 9, 2010 at 5:15 am

#1204073
RE: Case Statement in SQL

Declare @timeZone varchar(10)
Declare @ZoneTime varchar(30)
Set @timeZone='CT'
Set @ZoneTime = CASE
WHEN (datepart(hour,dateadd(hh,dbo.GetTimeZoneDiff(@timeZone),getdate())) - datepart(hour,'00:00') < 12) THEN 'Morning'
WHEN (datepart(hour,dateadd(hh,dbo.GetTimeZoneDiff(@timeZone),getdate())) - datepart(hour,'00:00') < 17)...
^{“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

August 9, 2010 at 5:07 am

#1204069
RE: case condition

SELECT CONVERT(DECIMAL(18,2),NULL) AS finalpremium
...works just fine. What datatype is the column finalpremium?
^{“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

August 9, 2010 at 4:49 am

#1204060
RE: UPDATE DateTime - how do I do it?

What client are you using to run the statement?
^{“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

August 9, 2010 at 4:43 am

#1204055
RE: Today's Random Word!

CirquedeSQLeil (8/6/2010)
Chris Morris-439714 (8/6/2010)
dbowlin (8/6/2010)
How do you spell relief? F-R-I-D-A-Y:-D
P
pfpfpfpfpfpfpfpfpfpfpfpfpfpf
Anyone care to guess Jason's religious background?
^{“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

August 6, 2010 at 9:39 am

#1203621

Viewing 15 posts - 7,546 through 7,560 (of 10,143 total)