Question about handling commit_table waits - Dear SQL Server professionals, Thank you for looking into my question. I have a 3 node cluster (with no shared storage !!) with...
List of all instance names in my server - In my computer I have installed 3 SQL Server instances (different editions). While connected to one of them and running [code...
File sizes in system tables - I am querying select * from sys.master_files in order to know the file sizes of my database files. I wonder what...
Convert Varchar field - I have a Varchar field with units in inches :( that i need to convert to an integer (Unfortunately the " and...
ADDING FIELDS WITH A SELECT STATEMENT - Can someone kindly help me with the query below: SELECT 1 AS ID, '1 Field, COALESCE(SUM(Field1)/1000,'0.0') AS Field FROM Table WHERE Condition='Money' and SecondCondition...
Large MSDB database - Good Morning, I have a SQL 2016 box that has a large MSDB database, the log file it self it 6gb....
Always on Install - Hi I am following these notes for always on install and have some basic queries: http://www.sqlservercentral.com/blogs/ganapathis-mssqllover/2017/02/20/alwayson-availability-groups-step-by-step-setup/ For step 9 Click the Add… button
Sanity check - Even if you had a tried and proven method of managing file growth, would you still think it ok to...
RedGate's SQL Doc and Extended Properties - I'm working on documenting our SQL data warehouse and am looking at getting RedGate's SQL Doc. I wanted to get...
OPTION (USE HINT ( 'FORCE_LEGACY_CARDINALITY_ESTIMATION' ))? - I need to review this simple query written by someone else a while ago, i have to review it for...
Returning same line number for each line on Subquery with XML Query - Hello community, I built this stored procedure to create an XML file with a specific structure and using Row_Number () to distinguish...
Bullk insert in sql server.. - Hi all , I have text file with second row is blank,data start with 3rd row .due to one server to ...
Multiple Joins - Hi guys, just a general question. I'm writing a query in order to create quite a large report. I have multiple...
Mirroring - Working on setting up SQL Server mirroring. Following are the steps I am thinking to do.. Take Full Backup and Transaction...
Embedded Product key - Hi Experts, We downloaded the image below from VLSC and install it on the server.We paid,and the product key is embedded. Do SQL...
Enforce Unique Constraint Across Two Tables - I have an interesting problem. An application allows users to "Tag" events with a label. Each user can put a...
Huge number of tables - Hi all, I've inherited a situation where we have a business critical system with gigantic number of tables, 240,000 - yes, nearly...
Is it possible to retrieve name(s) of SSIS package(s) that have an Exec SQL task that executes a specific SP? - Is it possible to find out names of SSIS packages scheduled via Agent that that execute a specific stored procedure...
File Delete Not Working Once Deployed - The following script embedded in a package works in the IDE but when deployed and run from an Agent Job...
Insert new records from one database to another using SSIS - I have a table with Table 1 ( taskid bigint , name varchar(200), tasktype varchar(500)) , what I trying to achieve is every...