Identity in a table used previous number - Hi all, I have something that does not make sense to me. If anyone can give me clues that will be...
Unable to run the restore command in Node2 from Node1 part of Alwayson DB addition - declare @databasename nvarchar(max) declare @sqlbackup nvarchar(max) declare @sqlrestore nvarchar(max) declare @PrimaryAG nvarchar(max) declare @SecondaryAG nvarchar(max) declare @backupPath nvarchar(max) declare @linkedserverName sysname select @sqlrestore = N'RESTORE DATABASE ' + QUOTENAME(@databasename) + ' FROM...
How to use 'between' in CASE statement? - Hi Friends, I am trying to wirte a filter condition in WHERE clause like CASE WHEN GETDATE() = 'first of this month' THEN 'DATE...
How to convert string to "data type" ? - Hello everybody, First of all sorry for my English ;-) Here is my problem. In a table I've : - MyValue : column (varchar) wich store...
problem in connect tosql of internet - hi i have coneccted to sql server with ip valid of sqlserver management password sa is 123456 type id server name : example:94.183,157.251,1433 username:sa password:123456 but ...
SignalR Deadlock - The below select is causing deadlock on our production box. How can i avoid this? The same query is running from...
Drop/Create objects versus Alter - I am trying to put together some standards documents for development on a new team, and I received some sage...
Help needed with configuring sp_rename ( Works well but how do we include the schema name ) - The following works well as it is...( if you enter the name of the object without the schema name in...
Why would SQL throw a Severity 016 alert?? following a successful db restore? - Hi all, Does anyone know why would SQL throwing a Severity 016 alert following a successful db restore, and what I...
Single Node MSSQL 2012 cluster to Always on - We need to migrate one of our MSSQL instances in Production . The outgoing replication is to Informatica and is very...
TEMPDB log growing HUGE - Running SQL 2012 SP3 CU6 AlwaysOn.... we had an issue two nights ago with the tempdb log filling the log disk....
Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060. - Hello. We have a very large table in one of our MSCRM deployments that has 566 columns with a variety...
translation to hours - Hi, I'm trying to normalize my data to hours and I'm a bit confused. For example, for 12 hours to 1 billed...
Little colored triangles on 2008 SSIS tool items - what do they mean? - Sorry if this is a basic question but I can not even create a search string that gets me close...
Insert data into a table without disabling the constraints (pk and fk) - Hi I am working with a t-sql code in SQL Server 2008 and would like to know if it is possible...
Removing cursor - Good morning, I have a store proc that uses cursor to update table with 80 million records.Iyt's extremely slow (runs over...
Specifying ReportServer database names during installation of Database Engine (named instance) and SSRS at command prompt - Hi, \setup.exe /Action=Install /QS /SQMREPORTING=0 /IACCEPTSQLSERVERLICENSETERMS /ERRORREPORTING=0 /Features=ADV_SSMS,BC,BOL,Conn,FullText,RS,SQL .... /INSTANCEID="SQLPROD01" /INSTANCENAME="SQLPROD01" will install 1.SQL instance SQLPROD01 2.Create reporting
Dealing with programmers - Hi Community, Dealing with programmers turns to be a difficult challenge, when they ignore his duties, because they do not have...
Copy data from flat file with multiple headers - Hi, I am trying to copy data from a flat file (CSV) which has multiple headers between the row values to...
create folders using t-sql - Hi, I have a requirement to create a folder structure in a directory path say (c:\test) with the number of rows...
