Production SSRS Report Issue - Hi All, Two days back we migrated one database from one server location to another server location, But now when we...
AlwaysOn vs Replication vs Mirroring - I learned that replikation gives you workable copies and mirroring only a backup in case of the "main" database fails. Now...
Such a hard time grasping the basics and understanding the logic!! - Hello everyone, I am new to TSQL development and well to be honest programming itself. All my life I avoided writing scripts and...
Encapsulating complex logic without using a scalar UDF - I have business logic for date comparisons that go beyond the typical DATEDIFF functionality. For example, when determining the number...
Remove all leading zeros from a column of data in SQL? - I have a data table called 'ItemNum' The column is a SKU, which is all numbers...the current format is: 028200136107 I need to...
Unable to fetch result from linked server - Hi Experts, In our production server, we are using one query to fetch the result from linked server, using one particular...
Update Query Performance - Hello Experts, Following update Query takes about 1 Millisecond to update a Product reserve under less Load. But when thousands of...
Covering Index - When and how do you use a covering Index?
Convert Cross Join to Inner Join - Hopefully this isn't too daunting given that I'm providing a rather lengthy piece of sample code. I understand that cross...
Incorrect sort order on using Top 1 with Unique Identfier Column views incorrect results in query - Hi Im using a view
Availability Groups Removed & Readded Database Problem :exclamation: - I had a bit of a server meltdown this morning that necessitated me removing one database from my availability group...
Unable to setup Subscriber - Hi, I'm unable to connect to remove server without mention of port number, but when I do that when specifying Subscriber...
Use dynamic database name in t-sql statement - Hi, I am sorry because I have duplicated this topic, Some one else tried to help me but I couldn't...
t-sql 2012 sort - In a t-sql 2012 view, I would like to sort the data by mailAddress. However a sort is not allowed...
Single quote for cross apply to use dynamic DBname - Hi, I have a sql query with cross apply function, it works fine when I set statically the DBname, but When...
OS error 665 - Not CHECKDB - Hi, SQL Server 2008 R2 Enterprise Edition - 10.50.6220 on a 2 node Windows 2008 R2 cluster. It's a dedicated host running...
SQL code for the below - SERVERS DB's SIZES DATES RANKING ServerA DB1 14642 2017-03-05 06:00:13.193 1 ServerA DB1 14497 2017-02-26 06:00:11
Redirect bad rows from Execute SQL Task - Hi, I have an SSIS package with an Execute SQL task which executes a proc and inserts rows in SQL table....
Build an architecture for highly confidential project - Hi Guru, I've a project which dealing with confidential data, such as payroll, medical information and etc. All these confidential data...
Difference between db_datareader and db_denydatawriter - Hi Everyone, Please explain me the difference between db_datareader and db_denydatawriter. Thanks & Regards, Naveen
