tag:blogger.com,1999:blog-6806992453823338600.comments2023-05-18T11:36:19.318-04:00SQL Server NewbieJerry Hunghttp://www.blogger.com/profile/00173468802063778170noreply@blogger.comBlogger42125tag:blogger.com,1999:blog-6806992453823338600.post-59740069987228747662016-05-05T12:31:02.622-04:002016-05-05T12:31:02.622-04:00Open a query in SSMS. In the menu bar, select Too...Open a query in SSMS. In the menu bar, select Tools -> Options -> Keyboard (Under the Environment node)<br /><br />Within the Press Shortcut Keys – Press the key you would like to assign to the shortcut to. In my case I have used F2. Within the commands box highlight Query.ChangeConnection and click on assign. This will now open up the SQL Server connection window on pressing F2.<br /><br />https://ashleybickerstaffe.wordpress.com/2016/05/04/change-sql-server-management-studio-ssms-connection-keyboard-shortcut/Ashley Bickerstaffehttps://ashleybickerstaffe.wordpress.com/2016/05/04/change-sql-server-management-studio-ssms-connection-keyboard-shortcut/noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-12792309325177939852016-02-23T01:19:20.154-05:002016-02-23T01:19:20.154-05:00Excellent information and facts. Only real difficu...Excellent information and facts. Only real difficulty I was basically receiving was viewing the pics. No idea exactly why. <a href="https://plus.google.com/111951783616208311688/posts/CeqNiU5EDic" rel="nofollow">obat kutil kelamin herbal tanpa operasi</a><br><br /><a href="https://www.facebook.com/denatureid/" rel="nofollow">obat kutil kelamin di apotek</a><br><br /><a href="https://docs.google.com/document/d/1EF0vysNjSKzOCSXIU2lhVd7ZAdHaIeGlK8O0kA-wbZ8/edit?usp=sharing" rel="nofollow">obat kutil kelamin paling jitu</a><br><br /><a href="https://twitter.com/iddenature/status/661428274371805184" rel="nofollow">gambar obat kutil kelamin</a><br><br /><a href="http://1800801inplantes.com/pengobatan-kutil-kelamin-khusu-pria.html" rel="nofollow">obat kutil kelamin paling murah</a><br><br /><a href="http://lidaspring.com/pengobatan-kutil-kelamian-dari-de-nature" rel="nofollow">obat tradisional penyakit kutil kelamin</a><br><br /><a href="http://edacomtecnologia.com/pengobatan-kutil-kelamin-khusu-wanita.html" rel="nofollow">obat kutil kelamin terbaik</a><br><br /><a href="http://reyesandassociates.com/cara-obat-kutil-kelamin-de-nature" rel="nofollow">jamu kutil kelamin mujarab</a>Anonymoushttps://www.blogger.com/profile/06410668656232746295noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-85308318906847538002016-02-17T08:45:10.064-05:002016-02-17T08:45:10.064-05:00Hi Jerry,
Can you please provide the script to re...Hi Jerry,<br /><br />Can you please provide the script to restore database from the backup directory for Full, latest Diff and all log after the latest diff backup.Anonymoushttps://www.blogger.com/profile/02605910003644757755noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-62668605592810591132016-01-15T06:44:10.747-05:002016-01-15T06:44:10.747-05:00Worked perfectly, nice simple solution, Wonder why...Worked perfectly, nice simple solution, Wonder why one cant select more than one in the notification setup though.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-8680977300012166182015-04-21T01:55:38.565-04:002015-04-21T01:55:38.565-04:00serverbuddies provides Quality remote server mana...serverbuddies provides Quality remote server management including troubleshooting, Server Management, Plesk Suppor, Server Maintenance, Server Monitoring, Server Troubleshooting and support for a large variety of customers at affordable rates. Here are option for Server Management, <a href="http://www.serverbuddies.com/" rel="nofollow">Server Maintenance</a>, Server Monitoring, Server Troubleshooting, Server Optimization, Plesk Suppo, Linux Support, cPanel Support and Plesk Support.<br />.........<br />elson cadehttps://www.blogger.com/profile/04601989980404314891noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-3738748446892145662015-02-25T05:13:20.614-05:002015-02-25T05:13:20.614-05:00Awesome it works "GUI"Awesome it works "GUI"Ads for local communityhttps://www.blogger.com/profile/18271954270511754969noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-61275772901402560802015-01-31T00:48:50.694-05:002015-01-31T00:48:50.694-05:00Hello,
A SQL maintenance plan for rebuilding index...Hello,<br />A SQL maintenance plan for rebuilding indexes and setting the index free space percentage to 10% within the Symantec/Arellia databases should be scheduled to run at least monthly (preferably weekly). This maintenance plan should also be configured to update column statistics (index statistics are updated during the index rebuild process).<a href="https://www.ibremarketing.com/" rel="nofollow">Server Maintenance</a> fitzjames41@gmail.comhttps://www.blogger.com/profile/00909179365697884199noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-43407516110238943492015-01-22T15:20:04.356-05:002015-01-22T15:20:04.356-05:00This seems absurd. Is there no way to perform a S...This seems absurd. Is there no way to perform a SELECT INTO for the RESTORE FILELISTONLY? This would cut half of this code down to one line.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-57962073132041592242013-02-26T15:13:31.404-05:002013-02-26T15:13:31.404-05:00Very helpful, thank you.Very helpful, thank you.Mike Fnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-42265965712786342412012-07-16T14:28:20.113-04:002012-07-16T14:28:20.113-04:00@John
I have made more changes to my current scri...@John<br /><br />I have made more changes to my current scripts, which basically does<br />1. BACKUP - backup * or select DBs to default/given location, using customized filenames<br /><br />2. RESTORE - restore from given location<br />find latest FULL, then latest DIFF after the FULL, then all logs AFTER the FULL<br /><br />The RESTORE script has an EXECUTION option that I rarely use as it sounds dangerous<br />No restriction on whether DB has to exist on target server or not. If DB exists, it'll be RESTORE WITH REPLACE; otherwise just RESTORE FROM DISKJerry Hunghttps://www.blogger.com/profile/00173468802063778170noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-62990260574082575632012-06-21T10:59:37.240-04:002012-06-21T10:59:37.240-04:00No idea if anyone is still maintaining this blog, ...No idea if anyone is still maintaining this blog, but I have a question about the above stored procedure. Do the databases have to exist on the target server for it to work? I'm looking to dynamically backup all databases from one SQL server to a share on another SQL server, and then to have your script automatically restore them to the second SQL server, and would like the script to automatically restore any new databases from the latest backup.<br /><br />Thanks!Johnhttps://www.blogger.com/profile/06457631855253517540noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-25745268359208432372012-06-07T10:08:03.279-04:002012-06-07T10:08:03.279-04:00Have you seen and used Ola Hallengren's award ...Have you seen and used Ola Hallengren's award winning solution?<br />I use it across 18 Servers and it works well for us. Offcourse, test it on some Development Server in your environment before you roll out. You can obtain it from: http://ola.hallengren.com/downloads.html<br />The MaintenanceSolution.sql script contains and creates all the Jobs. I modified it slightly for our environment, not to create the Backup Jobs, since I have already put in place our own custom backup solution.Anonymoushttps://www.blogger.com/profile/05704763080016773458noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-80418073370458596242012-05-17T06:58:46.470-04:002012-05-17T06:58:46.470-04:00ya it's working....
Thank you very muchya it's working....<br /><br />Thank you very muchKrishnachaithanya Alamhttps://www.blogger.com/profile/12404143902229664271noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-285674532198347072012-02-17T23:16:27.848-05:002012-02-17T23:16:27.848-05:00I think most of the time, people started with Data...I think most of the time, people started with Database Developer, and got into DBA; unless you're lucky to have a company that willing to develop you<br /><br />Or... you could've been the one man shop where you did everything (Developer+DBA+Sys Admin+Network Admin+etc...)Jerry Hunghttps://www.blogger.com/profile/00173468802063778170noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-32947301422458365552012-02-10T05:33:01.878-05:002012-02-10T05:33:01.878-05:00many thanks for taking the time to share this. For...many thanks for taking the time to share this. For some reason setting up using the wizard kept failing. This worked perfectly.JasMarthttps://www.blogger.com/profile/09247153195892891219noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-80366302457170327662012-02-08T13:34:55.265-05:002012-02-08T13:34:55.265-05:00How did you get your junior DNA role, did you have...How did you get your junior DNA role, did you have some prior experienceJ kingnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-25152482890715779882012-01-27T08:39:32.623-05:002012-01-27T08:39:32.623-05:00Thanks! works perfectly!Thanks! works perfectly!Henriquenoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-50078423457307009672011-11-03T05:20:11.332-04:002011-11-03T05:20:11.332-04:00It seems to me that Jerry Hung ment to say that, n...It seems to me that Jerry Hung ment to say that, newsequentialid() is better than newid() to have pk guid, which is correct since you avoid table splitting problem.Roberto Prevatohttps://www.blogger.com/profile/00847002118453678917noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-35585142993869139392011-08-20T13:28:03.436-04:002011-08-20T13:28:03.436-04:00This comment has been removed by the author.Alexhttps://www.blogger.com/profile/02892788277177092618noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-37704186371538612432011-04-19T04:32:40.583-04:002011-04-19T04:32:40.583-04:00Also it is not 'better' to use newsequenti...Also it is not 'better' to use newsequentialid at all - you might as well just use an identity column.<br /><br />It says the same in the SQL Server documentation.Lord Zoltanhttps://www.blogger.com/profile/18416046190284445908noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-3373917547894151362011-02-17T07:35:38.439-05:002011-02-17T07:35:38.439-05:00The RowGUID data type is uniqueidentifier with ...The RowGUID data type is uniqueidentifier with 'Is RowGuid' value = Yes and 'Default Value' = (newid())Anonymoushttps://www.blogger.com/profile/08276042543507378483noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-71059169748155308272011-02-17T07:26:05.821-05:002011-02-17T07:26:05.821-05:00The setting of RowGuid=yes is correct for a GUID p...The setting of RowGuid=yes is correct for a GUID pk.Anonymoushttps://www.blogger.com/profile/08276042543507378483noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-47736505341860938002010-11-05T15:03:16.565-04:002010-11-05T15:03:16.565-04:00Ha, even myself don't use Import/Export as I j...Ha, even myself don't use Import/Export as I just manually create a new MP with the GUI<br /><br />I couldn't recall why I needed to export or posted this article<br /><br />@anthonyx26 - I guesst trial and error! no harm in inserting when you can delete it easilyJerry Hunghttps://www.blogger.com/profile/00173468802063778170noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-57406250041806985392010-11-04T10:14:36.652-04:002010-11-04T10:14:36.652-04:00@RobK...thx for tip on new table name.
Ok...so I ...@RobK...thx for tip on new table name.<br /><br />Ok...so I ran query and it returns, amongst a few other records, the maintenance plan I seek to export to another SQL Server. So do I now just need to insert that value into the other server? As in:<br /><br />INSERT INTO sysssispackages (packagedata)<br />VALUES ('<DTS:Executable...')<br /><br />It seems like I will probably first need to modify the packagedata value to fit the params of the new server (chiefly, the server name). <br /><br />Then I guess it might be wise to manually create the maintenance plan (so SS creates all the IDs etc), with the same name, using SSMS. Then instead of the INSERT, do an UPDATE query with the new packagedata value.<br /><br />Sound about right? Or should I skip the step to create the MP manually? And if so, has anyone developed an INSERT that takes care of adding the required IDs as well?<br /><br />- anthonyx26Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-43792663574088997482010-10-29T14:09:24.476-04:002010-10-29T14:09:24.476-04:00In SQL 2008 SP1 you may need to use sysssispackage...In SQL 2008 SP1 you may need to use sysssispackages table instead.<br /><br />Thanks,<br /><br />Rob KosteckiAnonymousnoreply@blogger.com