How to Split a string by delimited char in SQL Server..............
However I posted this one in one of my post.
Querying Microsoft SQL Server : Functions in SQL Server: Functions in SQL...
2013-09-19
628,636 reads
Insert data from Excel to SQL Server
Here I am discussing about data insertion from MS Excel into SQL Server table. SSMS provides Export Import wizard by...
2013-09-16 (first published: 2013-09-11)
7,212 reads
Connection Pool limit exceeds Error
Sometimes below error occurs on our web applications hosted on IIS connected with SQL Server.
Timeout expired. The timeout period elapsed...
2013-09-13
32,205 reads
Sending Mail using SQL Server Express Edition
In SQL server standard and enterprise edition,A DataBase mail functionality in built to sent mail.But in SQL Server express edition,You...
2013-09-02
65,419 reads
How to find SQL Server Version,Edition,Server Name?
How to find sql server version,edition,Server Name?
SQL Server provides a System Defined function SERVERPROPERTY(propertyname) .
By using this function you can...
2013-08-31
26,254 reads
When and why you should use 1=1 in WHERE clause?
One Interviewer ask this question during interview of my friend.It is easy to answer but need some specific and to...
2013-08-24
1,259 reads
Remove duplicate records from a table in SQL server
Here I create a table and
inserted some duplicate records for testing purpose.
createtable temp(cust_id varchar(50))insertinto temp(cust_id)values('oms1'),('oms2'),('oms1'),('oms2'),('oms3')select*from temp
Method 1: (You can simply...
2013-03-19
3,834 reads
Querying Microsoft SQL Server : Basics of Indexes in SQL Server
Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...
2013-03-13
923 reads
Querying Microsoft SQL Server : Basics of Triggers in SQL Server
Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers: A trigger is a procedural code like stored...
2013-03-13
1,470 reads
Querying Microsoft SQL Server : Control Statements in T-SQL
Querying Microsoft SQL Server : Control Statements in T-SQL: Control statements are used to control execution flow within a T-SQL.Here I...
2013-03-13
752 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers