Exporting from Excel to SQL
In few business applications inputs to the system is in the form of an TXT / CSV / Excel file(s).This script will help how to upload an Excel file in to SQL Server.
2003-04-10
511 reads
Scripts
Get Relationship for your tables
Use this script to get relationship between ur tables (PK, FK), if defined. This script will give you base table and its columns (PK) with other related tables and columns (FK).So, no need to check in the diagram.Mohit NayyarMCP, MCAD (.Net), MCSD, MCDBA
2003-04-10
784 reads
List the current user list on given database
How to get a list of the users logged on to a specific database ? (instead of SP_WHO)
2003-04-09
336 reads
Running Total without using of Cursor
Script for computing Running Total on Table without using Cursors.
2003-04-09
412 reads
Script tables to emulate Copy in Enterprise Manage
This script will produce the same output as doing a Copy in enterprise manager and then pasting into Query Analyser.It can handle Clustered and Nonclustered Primary Keys, Multiple Foreign Keys, Defaults, Constraints, Identity Fields. If you are able to improve this script, or find any bugs, please let me know.
2003-04-09
182 reads
Clear all user objects
This procedure will drop (with care) all user-defined objects: constraints, procedures, functions, triggers, views and tables. Used for re-creating database schema without drop and create database.
2003-04-07
133 reads
Get File and Maximimum Size by Drive Letter
Utility Script to assist when you are thinking about expanding a database file. When Used in combination with srvinfo you can know just how far you can expand a file to keep the maximum file sizes from getting over the capacity of the drive.
2003-04-07
235 reads
Number of days for a given month
Use this function to get the number of days in a given month.Mohit NayyarMCP (.Net), MCSD, MCDBA
2003-04-06
424 reads
To retrieve Stored Procedure Parameters with Description
Use this procedure to get parameters for your stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Can be used to populate the dynamic parameters for any procedure. Mohit NayyarMCP (.Net), MCSD, MCDBA
2003-04-06
941 reads
View Input Buffers for all SPIDS
This procedure, sp_AllInputBuffers, uses dynamic T-SQL to generate and execute the DBCC INPUTBUFFER statement for each server process (except yours). Perfect for performance troubleshooting situations, when you want to see what commands are being executed against your server. Also, a great example of the power of dynamic T-SQL.For the @exec parameter, pass 1 or leave […]
2003-04-04
667 reads
Blogs
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
Forums
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now
Comments posted to this topic are about the item Five SQL Server 2022 T-SQL...
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers