Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,496 through 21,510 (of 59,072 total)

RE: Are the posted questions getting worse?

Grant Fritchey (2/17/2015)
Ed Wagner (2/17/2015)
Steve Jones - SSC Editor (2/17/2015)
Hope everyone had a great President's Day. We don't have the snow that Grant does, but we did get 8" 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)

February 18, 2015 at 6:31 am

#1778324
RE: Importing spreadsheet in one single column

Heh... the OP has left the building! 😛
--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 18, 2015 at 12:29 am

#1778264
RE: Next Business Day

Joe's suggestion is spot on for this. The only difference that I'd take is that I'd use the underlying date serial numbers for the dates so that you don't...
--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 18, 2015 at 12:28 am

#1778262
RE: chainging isloation level with in the sesssion after closing first tran is correct or not

Ok. Instead of guessing, setup a test and see what happens. It'll probably take less time to do that what we've already expended on this thread. 😀
--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 18, 2015 at 12:25 am

#1778261
RE: i have a situation please suggest some transactional solution

You building what is sometimes referred to as "poor man's replication". Wouldn't it just be easier to setup Transactional Replication and be done with 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)

February 18, 2015 at 12:23 am

#1778260
RE: How would you set up your server?

Steve Jones - SSC Editor (2/17/2015)
Grant Fritchey (2/17/2015)
Not mentioned is the OS. If I only have two drives, the OS on one and everything else on the other.
Any ref here?...
--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 18, 2015 at 12:19 am

#1778256
RE: Table structure for creating timetable for a school

MMartin1 (2/17/2015)
Using tables like a Calendar, Course, TimeOfDay table (separate from Calendar which implies a day as the primary key) or Period ...
you could employ a simple snapshot table...
--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 17, 2015 at 1:38 pm

#1778179
RE: Drop Column and Update column in sql

vipin_jha123 (2/16/2015)
Hi ,
I want to have chcecksum value of all the column in my table. In ssis pacakge I used script component MD5 , but now I have converted ssis...
--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 16, 2015 at 11:31 pm

#1777948
RE: Are the posted questions getting worse?

Lynn Pettis (2/16/2015)
... Mark one off, 11 days on the calendar to go. 11 days on the calendar to go, 11 days to go, ...
You're getting real close, Lynn....
--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 16, 2015 at 10:59 pm

#1777944
RE: Drop Column and Update column in sql

vipin_jha123 (2/16/2015)
Hi I am looking for standard sql code for below 2 concern
1- I want to drop the column Rowchecksum to all the table where table name start with ArchiveBbx
2-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)

February 16, 2015 at 10:54 pm

#1777943
RE: SQL Injection, Still?

Great article, Steve. There's been no excuse for any code that's susceptible to SQL or any other type of injection for years and yet it's still the most common...
--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 16, 2015 at 10:49 pm

#1777942
RE: Very little space of harddisk problem

Any changes the REORGANIZE makes to an index are fully logged in the log file rather than minimally logged if you do an index REBUILD in the BULK LOGGED mode....
--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 16, 2015 at 10:37 pm

#1777940
RE: Very little space of harddisk problem

WhiteLotus (2/16/2015)
I am serious 🙁 .. Sad really .. hey I got good news .. my Team just did something on that drive and got 17 GB free now .......
--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 16, 2015 at 4:04 pm

#1777920
RE: Automated 24 hour old copy of a live database required

I'll second Gail's recommendation. If it's a huge database, then something a bit more complicated might work better once it's setup.
--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 16, 2015 at 9:03 am

#1777849
RE: WHERE 1 = 1,who uses this besides me

GilaMonster (2/16/2015)
I hate seeing that in queries.
Ditto that.
--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 16, 2015 at 8:55 am

#1777846

Viewing 15 posts - 21,496 through 21,510 (of 59,072 total)