Forum Replies Created
Viewing 15 posts - 58,981 through 58,995 (of 59,102 total)
-
RE: increasingly slow performance on insert
Henk,
The problem with CLUSTERED indexes is that they live in the data and should just not be used for transactional tables. Inserting into the "middle" of a 4 million record...
--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) -
RE: How to Handle "Wide" Tables?...
I'll probably get a huge number of arguments from this but you're really opening yourself up to a world of hurt if you move into the TEXT datatype. They're difficult...
--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) -
RE: Performance required on > 4 million records
Colin,
First, if you are not using the Enterprise Edition, adding memory over 2 Gig is fruitless because the Standard Edition is limited.
If this is something like a daily, weekly or...
--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) -
RE: Generate SQL Script
Oh crud... I just checked some of the switches for the scptsfr.exe routine I told you about and I don't think it'll work because the login is always "SA". If...
--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) -
RE: Generate SQL Script
There's a nasty VB program at C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqldmo\vb\SQLScripts on the server. If you can't get to that
, there's an .EXE called "scptxfr.exe"...--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) -
RE: Rows 1 to 20, 21 to 40 etc.
Stefan,
This is similar to the procedure that I use although my inputs are a little different (easy for you to modify, if you want). Instead of inputing a row number,...
--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) -
RE: Problem with adding a month to February 28
Carl, these are similar to some of the others but thought I'd post it anyway
------ Finds the LAST day of NEXT month (Time=23:59:59.997) (resolution is 3 ms)
SELECT DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,0,@Date)+2,0))
...
--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) -
RE: Batching and index question
Just curious... are any of the joined "tables" really views? That's what happened to me at work... just did a SELECT * to see what I got back from a...
--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) -
RE: Max string length for exec command
NVarchar uses two bytes per character. There is no reason to use it unless there is something "language specific" or the system requires it.
--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) -
RE: Max string length for exec command
Using EXEC (@SQL1+@SQL2...@SQL4), have been able to do up to 32k. Target of exec has to be in ( ). Didn't try it but was once told the limit was...
--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) -
RE: Assigning Permissions
You can also create roles and assign individuals to roles. That way, if you need to change the permissions for a whole group of people, you just change the permissions...
--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) -
RE: Assigning Permissions
The systax of the GRANT command should be as follows:
GRANT permissiontype ON sqlobject TO grouporrole
See "Books on Line" under "GRANT, GRANT (described)" for a complete list...
--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) -
RE: Problem with between
- CASE
WHEN ABS(DATEDIFF(ss, x, y) ) <= 3
- THEN 'Y'
- ELSE 'N'
- END
- Don't forget that DATEDIFF will always TRUNCATE to the whole second.
- -2.9 seconds becomes -2 and 2.9 seconds becomes 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) - CASE
-
RE: Assigning Permissions
I believe you are looking for the GRANT command. See "Books on Line" for details.
--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) -
RE: varchar2 field needs quotes - Microsoft Server 2000
>it works until the caseno column contains an value that can't be converted to int.
Mike, you are absolutely correct. I was aiming at the original question and I guess I...
--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)
Viewing 15 posts - 58,981 through 58,995 (of 59,102 total)