Unable to restore a database on a new instance - [b]Scenario[/b] Moving database from: Microsoft SQL Server 2008 (SP4) - 10.0.6241.0 (X64) Apr 17 2015 10:56:08 Copyright (c) 1988-2008 Microsoft Corporation Enterprise...
Mirroring Automatic Failover - We are receiving the below Error message in Mirroring and principal server is failovering automatically to Mirror Server. Database mirroring connection...
Select query inside procedure taking long time, clustered indexes doing scans, need suggestion - I have a procedure, which is running very slow, and is being timed out without returning any records. [Reports] Table...
possible combinations for all rows in table - I have a table having three column Name Value1 Value2 Value3 A 1 2 3 B 4 5 1 C 2 3 1 I want...
recursive query to find out orphans - Hi, i need a query to find out all orphan over a hierarchical table with the code above i can get...
Problem configuring Database Mail - I used a script that I was able to successfully install on multiple servers but I can't get it to...
RAMDisk? Use it for TempDB? - RAMDisk used to exist in Windows NT. I used it and it worked really well. Then, it was eliminated in...
Transaction Log File removal - I have a database with two transaction log files, I have deleted one log file using alter database remove file...
Deny DML on a table - Hi all I have a table "test" in my "testdb" database. There is a user "user1" The user has access to...
Query optimization - Hello, I want to optimise the following query that is running so slowly. Please help or gimme an advice. MERGE dbo.LocalizedCategories AS...
Is there a way to extract only credit card numbers from text - i have below sample data, i try to extract valid credit card data. But i was not able to do...
trying to get rid of clustered index scan - I have statement below which does a merge join but does a clustered index scan with over 2 million rows...
Unexpected Behavior With TOP clause in a DELETE - I recently encountered some unexpected behavior, or at least not expected by me, using the TOP clause in a DELETE...
Converting time - from "seconds after midnight" - Hello all, We have time saved in our db in a seconds after midnight format and need to convert it to...
effective use of subquery with a where condition - Good day friends, i have the query below: There are two sub queries with joins, the first sub query requires a...
relative performance sizing/estimation - I'm trying to get a better understanding of relative performance expectations for different types of queries. For example, given a...
SSIS Excel import error - The situation is: Server A: runs alle the ssis jobs. Excel is located on a fileserver. Connection string Excel: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\Fileserver\somewehre\Excelfile.xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES"; The...
Weird Resource Database Message in Error Log - I'm getting this message in the error-log each time on a SQL restart. [quote] The resource database has been detected in two...
Split list of string into all possible combinations - I have a table that contains one column and is populated as follows: declare @table table ( Col varchar(100) ) insert @table ( Col...
SQL Query/JOB Error - Hi all, Need advise for my error Executed as user: NT AUTHORITY\NETWORK SERVICE. Arithmetic overflow error converting IDENTITY to data type int....
