Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,526 through 21,540 (of 59,098 total)

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
RE: Are the posted questions getting worse?

TomThomson (2/16/2015)
Sioban Krzywicki (2/15/2015)
TomThomson (2/14/2015)
Lynn Pettis (2/14/2015)
TomThomson (2/14/2015)
Eirikur Eiriksson (2/7/2015)
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?
Usually not - they're mostly American.
Tom, must say that I find this...
--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 6:26 am

#1777810
RE: Avoiding Cursors

Steve Jones - SSC Editor (1/22/2015)
bump
The difficult part for me is that I've already written about most of the generic solutions that I've used in the real world and 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)

February 15, 2015 at 5:50 pm

#1777744
RE: Copy multiple CSV files into database using stored proc , Need to Create new databases everytime

nikki123 (2/9/2015)
hi
I need to import multiple csv files and load into table and everytime new database has to be created .
I was able to create new databases using...
--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 15, 2015 at 5:30 pm

#1777743
RE: Copy multiple CSV files into database using stored proc , Need to Create new databases everytime

CooLDBA (2/12/2015)
I had done it in the past with similar requirements.
Ah... I'm sorry. Please accept my apologies. I didn't mean to be sarcastic on my last response. ...
--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 15, 2015 at 5:21 pm

#1777742

Viewing 15 posts - 21,526 through 21,540 (of 59,098 total)