Viewing 15 posts - 13,366 through 13,380 (of 26,486 total)
I would leave it in full recovery model. What I would look at is developing a set of processes that spreads out your index rebuilds so that it minimizes...
March 28, 2012 at 10:54 am
Eugene Elutin (3/28/2012)
...so let's say you did not mean to imply you would do a round trip to the database to get said GUIDs
...
Without "so let's say...". I didn't say...
March 28, 2012 at 10:48 am
Aty01 (3/28/2012)
I think so
So, show us what you have so far.
March 28, 2012 at 10:42 am
patrickmcginnis59 (3/28/2012)
Lynn Pettis (3/28/2012)
patrickmcginnis59 (3/28/2012)
GilaMonster (3/28/2012)
patrickmcginnis59 (3/28/2012)
Ninja's_RGR'us (11/23/2011)
Dev (11/23/2011)
(XYZ is still waiting for thanks :hehe:).
The most prolific poster post because it's the RIGHT thing to do. Not...
March 28, 2012 at 10:41 am
Aty01 (3/28/2012)
The customer details will be in the customer table.
Order details in the order table etc...
Each table has its own primary key.
Tables are linked...
March 28, 2012 at 10:39 am
veronica.smiley01 (3/28/2012)
Because I was told you will have to give too much security access on sql server agent.
Not sure I buy this argument. I have setup jobs that use...
March 28, 2012 at 10:28 am
patrickmcginnis59 (3/28/2012)
GilaMonster (3/28/2012)
patrickmcginnis59 (3/28/2012)
Ninja's_RGR'us (11/23/2011)
Dev (11/23/2011)
(XYZ is still waiting for thanks :hehe:).
The most prolific poster post because it's the RIGHT thing to do. Not to get anything...
March 28, 2012 at 10:24 am
You are welcome. I hope you also downloaded that book I gave you a link to since the pdf version is free. It may help you as you...
March 28, 2012 at 10:21 am
If you are creating a job to run an exe file, why wouldn't you use the cmdexec environment for the jobstep?
March 28, 2012 at 10:13 am
Adam Seniuk (3/28/2012)
I have been trying for...
March 28, 2012 at 9:56 am
Can you explain why based on what you have learned so far about normalization?
Also, how will you relate the two tables?
March 28, 2012 at 9:34 am
Unless you are experinece space issues on the disks, or you have experienced an unusual event in a database (large data import or delete), I would not shrink the t-logs....
March 28, 2012 at 9:20 am
patrickmcginnis59 (3/28/2012)
Lynn Pettis (3/28/2012)
patrickmcginnis59 (3/28/2012)
Ninja's_RGR'us (11/23/2011)
Dev (11/23/2011)
(XYZ is still waiting for thanks :hehe:).
The most prolific poster post because it's the RIGHT thing to do. Not to get...
March 28, 2012 at 8:55 am
okbangas (3/28/2012)
Interresting solution, I had not thought of that approach, and getting rid of the cast makes it slightly faster.
Just a slight change to the code shown here[/url].
To make it...
March 28, 2012 at 8:00 am
eric.lyons (3/28/2012)
convert(datetime,convert(char,getdate(),102))The inner convert removes the time portion. The outer convert brings it back to date
OP wants to retain the hour, only wants to drop minutes and seconds.
March 28, 2012 at 7:53 am
Viewing 15 posts - 13,366 through 13,380 (of 26,486 total)