Paged data without temp table and without cursor 2
I modified mbenothmane's script..plz refer to "Paged data without temp table and without cursor(http://www.sqlservercentral.com/scripts/contributions/947.asp)"
2003-11-03
146 reads
Scripts
Return Column as List of Comma Seperated Values
Need a comma seperated list of a particular column in a table. This will do the trick.
2003-11-03
626 reads
Transfer or Restore Logins to New Server
Not my script, but this script will transfer the logins to a new server or help you restore the in a DR situation with their correct passwords (encrypted).
2003-11-03
1,188 reads
Errorlog Notification
This script Notifies the user(s) whenever there is an Error logged in the Error message. It excludes the Error messages 15457 and 1073759806. These 2 Errors can be ignored. (I know we like to keep our Elogs clean but for some time you need to yield to them J ). You’ll see the first error […]
2003-10-30
1,275 reads
Join Column Values
This script will join a single selected column from a select statement into a varchar variable. This works similarly to the javascript join function with a few additional features. By default the values will be joined with commas unless an alternate delimiter is supplied. The user can specify if the delimited values should quoted. To […]
2003-10-30
567 reads
User-defined data type dependencies
MSSQLServer has got sp_depends system sp to display the dependencies for a stored procedure, table and view. sp_depends does not support to display the User-defined data type dependencies. For custom database, we will create user defined data types (UDDT) and add this UDDT to a column/variable in a table/stored procedure. This sp (UDTDepends) will help […]
2003-10-30
470 reads
Stabilize Index
This sp is used to update index in a database. This sp has got three optional varchar parameters. First parameter will take the tablename. Second parameter will take the indexname. Third parameter will take the fillfactor. The following option we can execute the sp in a user database.1. exec StabilizeIndexIt will update all index in […]
2003-10-29
303 reads
Identify Primary Key Violation Prior to Insert (Updated)
This script allows for testing if rows will cause a primary key violations prior to inserting the data. Offending rows are stored in a table so they can be used in subsequent queries or used to debug bad data issues. This updated version adds a timestamp to the duplicates table so that identifying when the […]
2003-10-28
1,875 reads
Paged data without temp table and without cursor
Stored procedure that return range of data from any table without using temp table or cursors. You don't even need to use the IDENTITY field in your target table. Check out and comments are welcomed
2003-10-27
315 reads
SQL Server Error Log Manager
Provides a method to regularly recycle the sql server error logs based on a given file size. If the current log file is larger than that size, then the current log is closed and a new log created.This proc takes one parameter, @MaxFileSize, which is the target file size. This parameter defaults to 10 MB. […]
2003-10-27
946 reads
Blogs
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers