copying a database from one server instance to another server instance - I am trying to copy a database from one server instance to another server instance. Both instances are viewable in...
difficult (for me) query to count available items - I have a difficult sql calculation to make, and I dont't find the answer. Can someone help me? I have a...
First / last item of a string in a nvarchar field - Hi together, I actually have a little Problem and no idea to fix that. I searched @ Google but with the search...
date fillers - dates in two rows - Hello All, I need a very efficient way to duplicate rows based on dates in rows. table structure is something as...
Removing Repeating Data From a Fuzzy Match Result - I'm in the process of cleaning up a lookup table we have that is used to match on a name...
DBCC CheckDB WITH TableResults - Does anyone have a reference to the columns (and preferably datatypes) in the output of the different versions - or at...
Script to later multiple sql authenticated logins on a SQL instance - Hi Does anyone have any scripts or tips for altering multiple sql authenticated logins on a sql instance. T-SQL or...
Replication (possible) issues - Hi all We have a 3rd-party software vendor who puts data into some SQL tables. We want to replicate the databases across...
Determining causes for performance difference in queries - Hi, We have an integration query running at 5am - simple view on 3 tables (2 tables have 4-6m rows) - on some...
Query Help - Here is the basic schema of table CREATE TABLE Test (ID INT, ProductCode VARCHAR(50), Quantity INT) INSERT INTO Test SELECT 1,'ABC', 1 UNION SELECT...
Update Statistics.. - Hi Experts, Trying to figure out if it might help in solving any performance issues by introducing an additional manual update...
Compare database structure - Hi All I am comparing databases( the struct
PLE - Hi All, Appreciate if anybody can help understand why the physical memory is divided by 4 to determine ideal Page Life...
How to categorise my customer last 3 year , 2 year and 1 year not billed? - Hi Friends, desc tab1 locn varchar(10) cust_no varchar(10) address varchar(10) desc tab2 cust_no varchar(10) bill_date datetime my expecting output is custno locn _no The condition is i want to...
Can I restore a single file .mdf to multiple files spread across disks - I am trying to create a 2nd copy of my database which is 200GB so that I can do Log...
Script out permissions - Azure SQL database - Hi Folks, Any one has a script to script out user permissions from Azure SQL database? I was not able to...
Dynamically read images from share path and display in report - Hi Will it be possible to display the images in SSRS from FTP path ? Two table invoice & image_info -- table invoice Invoice...
Data Flow Task Error: The version of ODBC Source is not compatible with this version of the DataFlow - So, that is the error I am getting when I attempt to execute my extremely simple SSIS package. How simple?...
Using dtexec to execute a file system package with project level connection managers - I'm new to SSIS. I'm trying not to be a help vampire ;-) http://www.skidmore.edu/~pdwyer/e/eoc/help_vampire.htm I've read
Cleaning up Replication Monitor - I have sucessfully removed an old publication and it subscriptions, but I am still seeing references to it in the...
