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
516 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
785 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
183 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
135 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
236 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
425 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
668 reads
Blogs
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Forums
Developer edition cannot connect from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Moving the Error Log
Comments posted to this topic are about the item Moving the Error Log
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers