Viewing 15 posts - 781 through 795 (of 859 total)
he might need both depending on what he is trying to accomplish. if he is using xp_commandshell to interact with the OS then he will most likely also need...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 26, 2012 at 11:33 am
patrickmcginnis59 (3/26/2012)
Abdul Walele (3/26/2012)
permission should be granted to users on the server level so that they can have the ability to create sql jobs and schedule them?
http://msdn.microsoft.com/en-us/library/ms187901.aspx looks to be...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 26, 2012 at 10:55 am
Brandie Tarvin (3/23/2012)
Sounds to me like the OP decided it was a PEBKAC error.
sure it was a PEBKAC error? i have found those are a little less common than...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 23, 2012 at 3:32 pm
eforta.it (3/22/2012)
Me again 🙂I don't think you can buy 2012 licence and run 2008 R2 instead...
i would agree. if you buy 2012 but do not install make sure...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 8:20 pm
hbtkp (3/22/2012)
i got the solution
you have some curious helpers. what was dont to fix the issue??
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 7:00 pm
you need to head to the other thread since its an exact copy of this post. posting again will only tick people off and cause them to not help....
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 6:57 pm
Sean Lange (3/22/2012)
capn.hector (3/22/2012)
Sean Lange (3/22/2012)
Even better, don't use loops. :hehe:i was waiting for that one. :w00t:
Somebody had to say it...and I was kind of surprised that neither Eugene...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 3:01 pm
Sean Lange (3/22/2012)
Even better, don't use loops. :hehe:
i was waiting for that one. :w00t:
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 2:23 pm
the only 2 ways i know of to reclame space is shrink the database and shrink the file. both of which fragment the indexes. if you rebuild the...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 2:16 pm
ames.f (3/22/2012)
for the Scheduled jobs, it is a single job with Dynamic SQL for each database or do you have seperate Stored procedures for each production database?
we use a separate...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 1:46 pm
is this for homework or an interview? kinda sounds more like homework
can you post the table DDL for the tables you are trying to match up? Please see...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 1:39 pm
Lowell (3/22/2012)
cross-database data migration does not belong in a trigger.
an outside process could error out, but the...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 1:26 pm
as long as you continue to license the 2008 r2 you continue to use until you upgrade i don't see a problem. also check if there is a time...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 22, 2012 at 9:10 am
GSquared (3/21/2012)
Any particular reason this has to be done via stored procedures? SSIS would be easier.
id agree that ssis would be easier. as far as Book3 giving you...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 21, 2012 at 12:49 pm
SQLRNNR (3/21/2012)
AV has the file locked
The data file is not associated with the database that you detached.
You don't have modify permissions with your user account to the location where...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 21, 2012 at 10:40 am
Viewing 15 posts - 781 through 795 (of 859 total)