Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,951 through 34,965 (of 59,102 total)

RE: Temp DB

subha.mcts2005 (2/22/2011)
Hi,
one of my production server Tempdb Mdf file has increased 2GB with in 2 Hours on today morning.
why it was happened? what are the causes for this?
please...
--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)

February 23, 2011 at 4:46 pm

#1290685
RE: View - Need Dynamic From Clause for Cross Server Select/Join

I think Chaz is talking about "synonyms" which work quite well for this sort of thing.
Of course, the best thing to do would be to make your production and test...
--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)

February 23, 2011 at 4:44 pm

#1290684
RE: Finding duplicate values in very large table. Select Row_number() over too slow

I guess I'd have to ask... why do they allow the "dupes" to continue?
--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)

February 23, 2011 at 4:29 pm

#1290681
RE: date for 15th Feb 12.00 a.m

Pink123 (2/23/2011)
Hi,
How would represent date for 15th feb 2011 12 a.m in the same format as getdate() does?
will it be something like this in sql server 2005
'2011-02-15 00:00:00.000'
Please help
Thanks,
The following...
--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)

February 23, 2011 at 4:20 pm

#1290679
RE: Help needed to decode comma delimited string and insert into tables

Ok... thanks. 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)

February 23, 2011 at 3:38 pm

#1290670
RE: Help needed to decode comma delimited string and insert into tables

JJH82 (2/22/2011)
hi kumar20, the script cannot process some name characters, e.g. '&', '<'
',2 Column_Names "FIELD_NAME" "READ_FLG" ,2 Old_Column_Values "Rural & Remote" "N" ,2 New_Column_Values "" ""'
'+2 Column_Names "ATTRIB_VALUE" "SCORE" +2...
--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)

February 23, 2011 at 6:46 am

#1290351
RE: Help needed to decode comma delimited string and insert into tables

JJH82 (2/21/2011)
yes, it does
, 8 Field_Name "1" "2" "3" "4" "5" "6" "7" "8"
thank you in advance
Ok... thanks... I'll try to take a stab at this tonight.
--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)

February 22, 2011 at 7:10 am

#1289842
RE: How to summarise, listing on same line

timotech (2/21/2011)
Hi Guys, I got it, this is the code i used, works ok
Very cool. Congrats and thanks for posting your final solution! 🙂
--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)

February 21, 2011 at 4:58 pm

#1289655
RE: Help needed to decode comma delimited string and insert into tables

Just a quick question, JJH82... does the number right after each coma identify how many elements there are for a given section?
--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)

February 21, 2011 at 4:31 pm

#1289650
RE: Help needed to decode comma delimited string and insert into tables

JJH82 (2/21/2011)
I appologise for the troubles I caused.
Here is a detailed structure of the source data:
1. the length of each row of string is not fixed
2. the data contained in...
--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)

February 21, 2011 at 4:24 pm

#1289649
RE: drop temp table in dynamic SQL

deeby (2/20/2011)
I'm importing excel data into SQL using SQLOLEDB, building up and then executing a command string with multiple OPENROWSET instructions.
I want to use a temporary table within the command...
--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)

February 21, 2011 at 4:01 pm

#1289646
RE: drop temp table in dynamic SQL

Craig Farrell (2/21/2011)
Deeby, can you post your actual code? It may have to do with your methodology.
If I'm right, you're getting something like the results of this:
SELECT 'abc' AS...
--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)

February 21, 2011 at 4:00 pm

#1289644
RE: Pivot Query with 2 aggregated functions combined?

Darundo (2/21/2011)
Before anyone asks, I did use search before deciding to post this but I didn't find anything to solve what I was looking for.
I have data that I want...
--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)

February 21, 2011 at 3:34 pm

#1289638
RE: Getting Up To Speed on SQL Server Denali

Most of the companies that I've worked for stay behind the bleeding edge by at least a service pack or two. Some stay close to a full version behind...
--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)

February 21, 2011 at 3:28 pm

#1289637
RE: Number of rows processed by a cursor

If it's in a separate "batch", you can probably get a fairly good idea of the rowcount using SQL Profiler. It won't be as perfect as putting a counter...
--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)

February 21, 2011 at 3:23 pm

#1289634

Viewing 15 posts - 34,951 through 34,965 (of 59,102 total)