Availability Groups either -- Windows 2016 Failover Cluster vs SQL Server Cluster - Hello, I supported SQL Server Clustering for a number of years, but now I am facing a task to implement Availability...
Finding levels in a hierarchy - i have some data which has a variable amount of hiearchy levels to it, DAX has a function called Path(),...
Insert in the Insert statement the previous value from the before value - CREATE TABLE .( NOT NULL, NOT NULL, PRIMARY KEY CLUSTERED ( ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,...
Assistance with DATETIME calculation when comparing to VARCHAR column (Test code included) - Hello, so I'm trying to get the difference in MINUTES between two columns. One column is a DATETIME column while the...
Scripts runs on 2017, but not on my 2016?? - Hello, I've got help over a few days getting a script to run and create data partitioning for tables. I'm...
xp_cmdshell in database administration - Hi colleagues. I made T-SQL script for automatic backup databases which is on AlwaysON availability group. Whole script works prorerly but...
DEVOPS with EDW - Wanted to kick off a discussion about Devops in the context of the enterprise data warehouse (EDW) One of the challenges...
Extended events question - Hi All, I have a question related to extended event ring buffer target. In SQL Server, how many ring buffer(s) will...
Find a value immediately prior to a given date - I have this code to create a temp table with 50,000 rows. CREATE TABLE #TEMP1(Part varchar(90),Supplier varchar (10),Import varchar (10),Summary...
Changing table name used in function, stored procedure and views - Our ERP Vendor decided to change the tables names. For example there use to be a table called customer now...
Left padding a FLOAT type with zeroes - Dear Friends, I'm in a situation where in I've to Left Pad a column of type Float with zeroesto a length...
remove Identity from a column - Hi Dudes, I have a Table Which has a column that is set to identity by mistake and it is on...
Migration of SQL Server 2008 R2 to AWS cloud - Hi, I am new to AWS cloud- can any one tell me what would be the steps to migrate SQL Server...
SSRS Next/Previous Functon Fetch - Is Any Function in SSRS Report Like Crystal Report, we can find the next record column data and compare with...
Error: The type of the value being assigned to variable "User::VARName" differs from the current variable type. - BIDS 2008. I need to create a bunch of text files inside ForEach loop in SSIS Package. 1 file is...
Project Deployment Model - Multiple Projects in a Solution - We've recently upgraded to SQL2014 and we're keen to move over to Project Deployment Model for our SSIS Packages. One...
T-Script Error on resetting Counter - Hello, When I run this T-SQL script that begins a dynamic way to create table partitions, I’m fine until the...
SQL Sever Scheduled Jobs - Hi, I'm trying to set up a scheduled job that runs daily and sends out an email to me when a...
Database stuck in single user mode - Hi, Suppose you had a database stuck in single user mode that is in a busy OLTP environment. Given that: 1. The connection...
Failed to notify ''operator name'' via email? - Following command sends email fine: EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'test message' However, SQL Job with a notification to above operator doesn't work. Job history...
