Viewing 15 posts - 841 through 855 (of 859 total)
you can try setting it to single user mode. then after you restore alter the database back to multi-user mode. is should work and will kill any connections...
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 12, 2012 at 3:46 pm
Sean Lange (3/12/2012)
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 12, 2012 at 3:40 pm
did you change the password in your configuration you posted to the web?? if not i would go change that now.
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 12, 2012 at 3:30 pm
Please see this link http://www.sqlservercentral.com/articles/Best+Practices/61537/
as far as the proprietary make up the data, make up the names. we dont need your production data but we do need something like...
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 12, 2012 at 12:10 pm
ok ill get past the multiple logins which seem to be the same person.
to get the various options you want you just keep adding case statements, so if you wanted...
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 12, 2012 at 11:27 am
there are 3 options i see, dynamic SQL based on the file name or 28 stored procedures, one for each file. for the dynamic SQL it may get complicated...
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 9, 2012 at 4:58 pm
here is a msdn article for the DST to ST switch (fall Back) and from it i think we can safely guess the jobs wont run. since the 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 9, 2012 at 2:59 pm
looks like this post is for this thread. http://www.sqlservercentral.com/Forums/Topic1263956-1292-1.aspx
however that query is hella ugly and really could be rewritten to work much faster as you are only working on...
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 9, 2012 at 2:04 pm
We can probably help. it will most likely take 2 inserts. other than that not much any one else can do with out sample data and table definitions.
Please...
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 9, 2012 at 1:49 pm
Along with bulk copy you could also use an SSIS package. might take a little work but you can also do some data transformation with the ssis package as...
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 9, 2012 at 1:42 pm
you can look at the SQLAgentReaderRole. this might be the solution you are looking for. check out the msdn article at the link
http://msdn.microsoft.com/en-us/library/ms188283.aspx
use msdb
EXECUTE sp_addrolemember 'SQLAgentReaderRole', 'username'
GO
EDITED TO...
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 9, 2012 at 9:09 am
if the scripts you are referring to are the T-SQL scripts, you can schedule a one off sql server agent job to run the script. in the scheduling section...
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 6, 2012 at 4:34 pm
SQL KnowItAll thanks for pointing out the TVF's made this alot more efficient. krhind, Here is the function followed by the query that will produce your requested output. ...
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 4, 2012 at 9:09 am
i am not familliar with TVF's off to the all mighty google to eliminate my while loop
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 2, 2012 at 5:37 pm
You have to loop through the dates, personal preference is a WHILE loop. below is a stored procedure where you can pass the string all or a specific customer...
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 2, 2012 at 4:01 pm
Viewing 15 posts - 841 through 855 (of 859 total)