Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,516 through 22,530 (of 59,099 total)

RE: updating a 25 million records in batches

klineandking (11/11/2014)
i have asked the question,assume both tables are a heap,how would you update the table in batches of 5000
Unless there's an index on the EncryptionID of both tables, the...
--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)

November 11, 2014 at 8:46 am

#1757706
RE: Cross Tab/Pivot

Never mind. I believe the following does what you ask. You'll need to change the table name in the FROM clause to whatever your tablename actually is. ...
--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)

November 10, 2014 at 8:34 pm

#1757600
RE: Cross Tab/Pivot

tamer.h (11/10/2014)
Good Day for everybody,
here is a table shows the dates and times of entry and exit of staff throughout the day, where each record shows that either employee's entry...
--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)

November 10, 2014 at 5:37 pm

#1757598
RE: variable char

What this whole thing looks like is the possibility of SQL Injection. It also looks like a "Catch All" query and the proper way to do it can be...
--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)

November 10, 2014 at 5:13 pm

#1757597
RE: Query becoming slower when records are retrieved..how to make it faster

Caching is a good idea but with only 10,000 rows, this should be sub-second. The correct indexes will make that happen.
Shifting gears a bit, if you really...
--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)

November 10, 2014 at 3:56 pm

#1757574
RE: Report ignores WHERE clause in SPROC

thottle (11/10/2014)
Are you absolutely sure that something other than WidgetA and WidgetB have data for the last 7 days?
Yes. If it doesn't, dataset 2 tossed up a blank report,...
--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)

November 10, 2014 at 3:04 pm

#1757568
RE: hi...this is chandra

chandrachamarthi8 (11/10/2014)
it display the schema on the result
Look carefully. Are you sure that it shouldn't be spelled "customer" instead of "coustmer"?
--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)

November 10, 2014 at 2:59 pm

#1757567
RE: Report ignores WHERE clause in SPROC

thottle (11/10/2014)
I've got a strange one in SQL Svr 2008R2.
I wrote a report that pulls datasets from two different SPROCs.
Dataset 1 has the following code (sanitized to protect the...
--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)

November 10, 2014 at 2:43 pm

#1757565
RE: Updating Tables

mhildebrand (11/10/2014)
Steve, apologies about my terminology - still learning and realizing it makes a huge difference. I think you hit the crux. i just don't think there is...
--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)

November 10, 2014 at 2:37 pm

#1757561
RE: Query becoming slower when records are retrieved..how to make it faster

Do you have the correct indexes on the table to support the hierarical lookups caused by the recurssion of the CTE? Also, who is going to read 10,000 rows?
--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)

November 10, 2014 at 9:34 am

#1757466
RE: How to catch even and odd weeks?

If it's supposed to be based on ISO week number, substitute the ISOWEEK datepart in Sean's good code above.
--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)

November 10, 2014 at 7:40 am

#1757430
RE: Log Backup size bigger than Full Backup

haichells (11/10/2014)
Hi,
I have a 2008 database where I take Full backup on Saturday and Log backup (once in a day) for rest of the days. Here my log backup files...
--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)

November 10, 2014 at 7:34 am

#1757429
RE: Are the posted questions getting worse?

Steve, I have an idea. Set it up so that when I report a post as spam and I include a secret word in the report, have the system...
--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)

November 9, 2014 at 7:06 pm

#1757349
RE: how to import a series of files with different columns

There's one other difference depending on how it's coded. Performance. RBAR inserts tend to be incredibly slow compare to multi-row set-based inputs.
Which brings me to a subject...
Lot's of...
--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)

November 8, 2014 at 8:16 pm

#1757325
RE: Min valuee of column (ignoring blanks, Nulls, zero)

Would [font="Courier New"]WHERE somecolumn <> 0[/font] do it for you?
--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)

November 7, 2014 at 10:06 pm

#1757292

Viewing 15 posts - 22,516 through 22,530 (of 59,099 total)