Viewing 15 posts - 18,211 through 18,225 (of 59,069 total)
Lowell (3/3/2016)
this script from awhile ago started it:
Powershell script to script out jobs, databases, users, linked servers, logins, roles, alerts, etc from a list...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 2:19 pm
tony28 (3/3/2016)
If this is only test server, the data transfer and how much time doesnt matter...
I have to strongly disagree with that. Some poor bugger in a pinch will...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 2:14 pm
chuck.forbes (3/3/2016)
Inside your function, you can just write T-SQL code, as the...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 10:28 am
tony28 (3/3/2016)
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D in this article is "Create Some Data"
So create new table or...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 7:17 am
Grant Fritchey (3/3/2016)
Jeff Moden (3/2/2016)
sickb00000y (3/2/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 7:12 am
moid.hassan (3/2/2016)
Thanks a lot for your response. I will first try with setting the Transaction Option as required.
Heh... WHY? Are you looking forward to an all-night rollback? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 10:16 pm
oneteabag (3/2/2016)
...but the challenge is every section is pretty much relying on the output from the previous section.
So why not use the single proc with the 4,000 lines of...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 10:12 pm
For each table to be loaded...
1. Rename the table with an "_A" suffix.
2. Make an identical table with an "_B" suffix.
3. Make a synonym with the same name as the...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 10:03 pm
prem.m38 (2/16/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 9:01 pm
Steve Jones - SSC Editor (3/2/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 7:50 pm
sickb00000y (3/2/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 7:46 pm
SmackMule (3/2/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 7:42 pm
SmackMule (3/2/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 7:05 pm
chuck.forbes (3/2/2016)
SELECT serial_number,
fn_error_code(serial_number) as err
FROM t
WHERE fn_error_code(serial_number) is...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 5:44 pm
Steve Jones - SSC Editor (3/2/2016)
Find all backup files for a dbdelete old backup files (delete .baks older than the last 2)
copy backup files to new folder, based on criteria.
Which...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 2, 2016 at 3:19 pm
Viewing 15 posts - 18,211 through 18,225 (of 59,069 total)