Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,156 through 25,170 (of 59,099 total)

RE: Need ideas on how to handle the inserting of millions of rows per day

ItsDaveTime (12/14/2013)
Thanks for your responses. I've been doing this for many years (as I'm sure you have as well) and have implemented and developed high availability and high transaction...
--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)

December 14, 2013 at 4:44 pm

#1673494
RE: Need ideas on how to handle the inserting of millions of rows per day

aaron.reese (12/14/2013)
Also, Tell your C# developer that the underlying DB is none of his damn business - He should be using sprocs or LINQ to get data in and out...
--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)

December 14, 2013 at 4:02 pm

#1673492
RE: Restore Issues - Database In use mode?

First of all, I strongly recommend against killing SPIDs for anything ever. It's a documented problem on CONNECT that the KILL process can leave spids that consume large amounts...
--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)

December 14, 2013 at 3:29 pm

#1673488
RE: Encrypt Everything

I absolutely agree with the concept of encrypting everything in transit but...
Why does it seem that it always comes back to this recent bloody NSA thing? Where the hell...
--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)

December 14, 2013 at 3:03 pm

#1673484
RE: Write big table to csv

pven (12/14/2013)
...what is a good method to give users freedom to make their own queries...
To be absolutely honest, that statement is a bit of an oxymoron because most users are...
--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)

December 14, 2013 at 2:28 pm

#1673480
RE: Articles and IP Protection

tmlink99 (12/13/2013)
It's odd that nodoby here could just say what you do.
BWAAA-HAAA!!!! I don't find it odd at all! This isn't a legal forum and, to the best...
--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)

December 14, 2013 at 11:52 am

#1673476
RE: Are the posted questions getting worse?

Revenant (12/14/2013)
I am still thankful that I do not have to shovel it.
BWAAA-HAAA!!!! I sometimes feel like that when reviewing code. 😀
--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)

December 14, 2013 at 9:32 am

#1673472
RE: Table join / pivoting question

I doubt that you're actually using Table Variables for the real thing but we'll continue with that example. In the following, I've added indexes to the Table Variables 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)

December 13, 2013 at 9:15 pm

#1673453
RE: SQL server 2005 get slow after rebuild index online on few tables

There are so many different things that this problem could be. For example, if the index rebuilds made the INDEX SEEKs possible, it may ironically be the problem. ...
--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)

December 13, 2013 at 8:09 pm

#1673449
RE: Nested CASE WHEN in SELECT

Sean Lange (12/13/2013)
ChrisM@Work (12/13/2013)
Sean Lange (12/13/2013)
ChrisM@Work (12/13/2013)
Sean Lange (12/12/2013)
Yes David is on the right path here. A case expression has not bearing on the number of rows returned, it merely...
--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)

December 13, 2013 at 7:56 pm

#1673448
RE: Advice about how to educate non technical bosses on new job

Sean Lange (12/13/2013)
I would try talking to the network admin on a one to one basis. Be understanding (remember they are a junior network admin). This is where you get...
--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)

December 13, 2013 at 7:45 pm

#1673446
RE: EAV or XML

N_Muller (12/12/2013)
I have a set of tables in database where I cannot change its structure. I need to create extensions to the tables by adding new attributes (columns). ...
--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)

December 13, 2013 at 7:40 pm

#1673445
RE: Convert nanoseconds since 1/1/1601

Jeff Moden (8/7/2008)
You mean to tell me that LDAP queries can't change the format of the date?
BWAAA-HAAA!!!! I guess a more than 5 year wait for an answer means,...
--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)

December 13, 2013 at 7:03 pm

#1673442
RE: SQL server 2005 get slow after rebuild index online on few tables

If the job that does the 120 row/minute processing is either inserting or updating the rows on the tables in question AND the indexes have a 100% FILLFACTOR, then 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)

December 13, 2013 at 6:46 pm

#1673441
RE: Long Path Names to Files on SQL Server Installation

cathy.baker (12/13/2013)
I renamed the folder that was WAY long to something shorter and simpler then mapped the drive. That fixed the problem.
Thanks for the feedback, Cathy.
--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)

December 13, 2013 at 6:33 pm

#1673440

Viewing 15 posts - 25,156 through 25,170 (of 59,099 total)