Viewing 15 posts - 91 through 105 (of 109 total)
Thanks for sharing, nice bicycle.
But guys, try Brent Ozar stored procedures, it is much better and mature: https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit
August 8, 2016 at 3:15 am
Guys, please use sp_whoisactive: http://sqlblog.com/blogs/adam_machanic/archive/tags/sp_5F00_whoisactive/default.aspx by Adam Machanic
August 4, 2016 at 8:07 am
Another extended list of all SQL Server Version in markdonw format on Github: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Version.md
July 12, 2016 at 9:46 am
Pure powershell solution from Thomas LaRock:https://github.com/ktaranov/sqlserver-kit/blob/master/PowerShell/SQL_Server_linked_server_connection_check.ps1
May 27, 2016 at 2:07 am
Full version (with more additional info and useful link) on Github:
https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Version.md
Also if you interested in SQL Server Trace Flags list on github it here:
https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md
May 19, 2016 at 12:42 pm
Another solution with powershell script by Thomas LaRock:
https://github.com/ktaranov/sqlserver-kit/blob/master/PowerShell/SQL_Server_linked_server_connection_check.ps1
May 17, 2016 at 5:06 am
Thanks for your post, JHart4444!
You can add issue on Github or grab last version: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql or just comment 224 and 225 rows in code:
EXECUTE dbo.usp_LogError;
EXECUTE dbo.usp_PrintError;
Also you could find useful...
April 18, 2016 at 10:03 am
Why are not use awesome Glenn Alan Berry (http://www.sqlskills.com/blogs/glenn/) diagnostic queries (https://github.com/ktaranov/sqlserver-kit/tree/master/Scripts)?
February 8, 2016 at 6:26 am
Hello guys.
Another awesome solution for calendar table from Sean Smith (great thanks Sean, we used it intensively): https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Date%20Calendar%20Cross-Reference%20Table.sql
January 25, 2016 at 10:53 pm
My negative emotions after viewing 5 stars for this script: http://www.sqlservercentral.com/scripts/db+name/133720/
November 26, 2015 at 12:23 pm
brad.pears (6/3/2015)
More description on what is actually going on in the script along the way for SQL newbies would have been nice but otherwise very nice...
Hello, brad.pears. Thanks for your...
June 4, 2015 at 12:52 am
Iwas Bornready (6/2/2015)
Thanks for the script. I may have a use for this one. Thanks again.
Thank you for your reply. I updated procedure description on github (for using full name...
June 2, 2015 at 8:21 am
pawel.sowka (5/28/2015)
Why, I always get
Error = [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'table'.
Table exists.
Any table return the same error.
Hello, pawel.sowka.
Sorry for troubles, you should use full table name...
May 28, 2015 at 12:42 am
rw_ebox (5/21/2015)
Surprise, people still use bcp. I love this script.
Thanks for your reply. For my opinion and practice bcp the best solution for quick export big tables (millions rows and...
May 22, 2015 at 4:40 am
Viewing 15 posts - 91 through 105 (of 109 total)