ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,906 through 4,920 (of 10,143 total)

RE: Slows system performance

Krishna1 (4/7/2013)
...When my process is going on, its very difficult to open any other winow/exploer ....
Are you running this process on <local>?
^{“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 8, 2013 at 1:36 am

#1604294
RE: Are the posted questions getting worse?

rodjkidd (4/5/2013)
Steve Jones - SSC Editor (4/5/2013)
Cadavre (4/5/2013)
rodjkidd (4/4/2013)
Hotel booked for SQLBits. Almost forgot all about that so a nice refreshing 20 minute walk in the morning!
I'm in Castle Marina...
^{“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 5, 2013 at 8:43 am

#1603935
RE: auto foreign key generation

Can you post the whole query please?
^{“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 5, 2013 at 8:06 am

#1603917
RE: Are the posted questions getting worse?

Cadavre (4/5/2013)
ChrisM@Work (4/5/2013)
You've been spending waaaay too much time in front of a computer 😀
I can find at least one person that would not only agree with you, but would...
^{“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 5, 2013 at 7:36 am

#1603901
RE: Are the posted questions getting worse?

Cadavre (4/5/2013)
ChrisM@Work (4/5/2013)
13.9 miles. You have to like your whisky.
Evidently my geography is a little off 😀
You've been spending waaaay too much time in front of a computer 😀
^{“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 5, 2013 at 7:29 am

#1603898
RE: Are the posted questions getting worse?

Cadavre (4/5/2013)
ChrisM@Work (4/5/2013)
Not sure how it will pan out yet. With a couple of good mates in the immediate area and a nearby pub boasting 180 different whiskies[/url], it's a...
^{“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 5, 2013 at 7:22 am

#1603892
RE: Are the posted questions getting worse?

Grant Fritchey (4/5/2013)
ChrisM@Work (4/5/2013)
Not sure how it will pan out yet. With a couple of good mates in the immediate area and a nearby pub boasting 180 different whiskies[/url], it's...
^{“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 5, 2013 at 7:13 am

#1603886
RE: Are the posted questions getting worse?

rodjkidd (4/5/2013)
Cadavre (4/5/2013)
rodjkidd (4/5/2013)
Nice.
So I take it you will jogging there and back then? 😀
I hate distances like that. Too far to walk, to short a drive for the car...
^{“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 5, 2013 at 6:58 am

#1603875
RE: Are the posted questions getting worse?

Cadavre (4/5/2013)
rodjkidd (4/4/2013)
Hotel booked for SQLBits. Almost forgot all about that so a nice refreshing 20 minute walk in the morning!
I'm in Castle Marina Premier Inn, which according to Google...
^{“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 5, 2013 at 6:16 am

#1603863
RE: Concatenate fields by specifying the start position of the next filed

Why don't you simply concatenate into fixed-width, like this?
DROP TABLE #table_x
CREATE TABLE #table_x (Empno INT IDENTITY(3141593,31415), FirstName VARCHAR(25), LastName VARCHAR(25))
INSERT INTO #table_x (FirstName, LastName) VALUES
(('Francis'),('Bacon')),
(('Jean'),('Baptiste')),
(('Clarence'),('Birdseye')),
(('Charles'),('Babbage')),
(('John'),('Logie Baird'))
SELECT *,
Concatenated_FixedWidth...
^{“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 5, 2013 at 3:41 am

#1603839
RE: How to switch ID number to new values (but maintaining duplicates for new ones)

lda17_04 (4/4/2013)
Hello!!!
I need a database from an Insurance company, but they don't want to give it because it has a column with the ID number of each patient and their...
^{“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 5, 2013 at 3:19 am

#1603835
RE: Help me tune this query...Please. :)

Use ROW_NUMBER, something like this:
USE SQLsafeRepository;
;WITH UnfilteredResult AS (
SELECT CASE WHEN LEN(p4.[name]) = 0 THEN p5.[name] ELSE p5.[name] + '\' + p4.[name] END AS server_instance_name
,p3.[name] [database_name]
,p4.[name] AS 'instance'
,p5.[name] AS 'server'
,p2.start_datetime
,p2.action_status
,p1.backup_type
,p2.utc_offset
,DATEDIFF(ss,p2.start_datetime,p2.end_datetime)...
^{“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 5, 2013 at 1:56 am

#1603827
RE: elegant strategies for complex update statements?

sqlguy-736318 (4/4/2013)
What I'm suggesting is that table #a would have 2 rows with the same company. For example:
'Microsoft', 'Seattle'
'Microsoft', 'Portland'
In this scenario, row #1 would get updated but row...
^{“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 5, 2013 at 1:41 am

#1603823
RE: Which of the two queries is better ???

Post the actual execution plan of the "Big Query" as a .sqlplan attachment.
^{“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 5, 2013 at 1:23 am

#1603821
RE: Slows system performance

Krishna1 (4/4/2013)
Dear All
I am running a process (updation/deletion/insert) of 2 million records. After some time this process makes my system very slow.
How do i find out whats the issue.
In...
^{“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 5, 2013 at 1:21 am

#1603820

Viewing 15 posts - 4,906 through 4,920 (of 10,143 total)