{"id":418,"date":"2021-04-08T21:54:14","date_gmt":"2021-04-08T21:54:14","guid":{"rendered":"https:\/\/datarebus.com\/?page_id=418"},"modified":"2022-12-29T11:08:28","modified_gmt":"2022-12-29T11:08:28","slug":"sql-server-blogs","status":"publish","type":"page","link":"https:\/\/datarebus.com\/index.php\/sql-server-blogs\/","title":{"rendered":"SQL Server Scripts"},"content":{"rendered":"
\n \n
\n \n
\n \n <\/path>\n <\/svg>\n <\/div>\n
\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n
\n \n \n

SQL Scripts<\/h2>\n <\/div>\n <\/div>\n
\n \n \n
\n

That Make Your Life Easier<\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n
\n \n \n
\n \n
\n \n
Daha Fazla SQL \u0130pu\u00e7lar\u0131 i\u00e7in SQLPIAZZA.COM<\/span><\/a>\n <\/span>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n
\n \n
SQL BLOGS<\/a>SQL Scripts<\/a><\/div><\/div>

SQL Server 2016 Database Mail cannot send email smtp.office365.com<\/h4><\/a><\/div><\/div>
by<\/span> admin<\/a> <\/span><\/div>
on<\/span> \u015eub 7<\/a><\/div><\/div>
Define your SQL Email ConfigurationWrite \u201csmtp.office365.com\u201d as server namePort should be 587 […]<\/div><\/div><\/div>
Read more<\/span> <\/path><\/svg><\/span><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n \n \n
SQL Scripts<\/a><\/div><\/div>

Make Network Path Visible For SQL Server Backup and Restore in SSMS<\/h4><\/a><\/div><\/div>
by<\/span> admin<\/a> <\/span><\/div>
on<\/span> A\u011fu 17<\/a><\/div><\/div>
You want to backup or restore a database but you cannot see […]<\/div><\/div><\/div>
Read more<\/span> <\/path><\/svg><\/span><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n \n \n
SQL Scripts<\/a><\/div><\/div>

Which Index\/Table is in which Datafile?<\/h4><\/a><\/div><\/div>
by<\/span> admin<\/a> <\/span><\/div>
on<\/span> Haz 17<\/a><\/div><\/div>
Let's assume that you have created separate datafile for non-clustered indexes but […]<\/div><\/div><\/div>
Read more<\/span> <\/path><\/svg><\/span><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n \n \n
SQL Scripts<\/a><\/div><\/div>

Scripts to find Logins with easy password<\/h4><\/a><\/div><\/div>
by<\/span> admin<\/a> <\/span><\/div>
on<\/span> May 21<\/a><\/div><\/div>
SELECT NAME,NAME ‘password’FROM sys.sql_loginsWHERE Pwdcompare(NAME, password_hash) = 1UNIONSELECT NAME,‘Blank’ AS ‘password’FROM sys.sql_loginsWHERE […]<\/div><\/div><\/div>
Read more<\/span> <\/path><\/svg><\/span><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n \n \n
SQL BLOGS<\/a>SQL Scripts<\/a><\/div><\/div>

Query to List Size of the Table with Row Counts<\/h4><\/a><\/div><\/div>
by<\/span> admin<\/a> <\/span><\/div>
on<\/span> Nis 19<\/a><\/div><\/div>
This query helps you identify your tables and calculate size\/rowcount ratio easily: […]<\/div><\/div><\/div>
Read more<\/span> <\/path><\/svg><\/span><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n \n \n
SQL BLOGS<\/a>SQL Scripts<\/a><\/div><\/div>

Set Identity_insert ON\/Off<\/h4><\/a><\/div><\/div>
by<\/span> admin<\/a> <\/span><\/div>
on<\/span> Nis 19<\/a><\/div><\/div>
Assume that all we know why we are using IDENTITY column in […]<\/div><\/div><\/div>
Read more<\/span> <\/path><\/svg><\/span><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n \n \n
SQL BLOGS<\/a>SQL Scripts<\/a><\/div><\/div>

PAGE LIFE EXPECTANCY<\/h4><\/a><\/div><\/div>
by<\/span> admin<\/a> <\/span><\/div>
on<\/span> Nis 9<\/a><\/div><\/div>
SQL Server i\u00e7in tan\u0131mlanan memory alan\u0131 ne kadar yeterli sorusuna en iyi […]<\/div><\/div><\/div>
Read more<\/span> <\/path><\/svg><\/span><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n \n \n
SQL BLOGS<\/a>SQL Scripts<\/a><\/div><\/div>

SET LOCK_TIMEOUT<\/h4><\/a><\/div><\/div>
by<\/span> omerzeybek<\/a> <\/span><\/div>
on<\/span> Mar 2<\/a><\/div><\/div>
When any connection starts the value of the SET LOCK_TIMEOUT is -1, which […]<\/div><\/div><\/div>
Read more<\/span> <\/path><\/svg><\/span><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n \n \n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"

SQL Scripts That Make Your Life Easier Daha Fazla SQL \u0130pu\u00e7lar\u0131 i\u00e7in […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/homepage.php","meta":[],"_links":{"self":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/pages\/418"}],"collection":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/comments?post=418"}],"version-history":[{"count":20,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/pages\/418\/revisions"}],"predecessor-version":[{"id":1512,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/pages\/418\/revisions\/1512"}],"wp:attachment":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/media?parent=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}