HA and DR Solution - Based on the discussions that we had internally we initially decided to move with a SQL FCI for our non...
Migrate SQL Server to new server - Hello All, I would like to upgrade my SQL Server 2012 to SQL Server 2016. I created new machine and i would...
Date Ranges - Simple, but seemingly impossible - Hi all, I've done a lot of research and tried so many things for around a week. I'm desperate at this...
Adding batch numbers based on row count and column values - Hi, I have to insert sales order data from a staging table to a base table where further processing is done...
sp_WhoIsActive and build warnings in VS Database Project - I just tried adding sp_WhoIsActive to a VS database project (for a non-system database – not sure whether that is an...
Memory pressure - Could WaitForDelay function cause memory pressure like I'm seeing this below? I have a sql server agent job that generates...
Encrypt a column in sql server? - Hi All, Need help in encrypting a column and share the encryption key with the person whom I want to...
Linked servers cannot be used under impersonation without a mapping for the impersonated login - Hi all I have a stored procedure that selects data from two instances. If I run the stored procedure it works...
Integration Services Catalogue (SSISDB) - Cannot return free space to operating system. - We have the SSISDB database which stores log information of jobs that are run. It was initially set to retain...
Need help with T-SQL - I have more than 200 tables in one of our database and those tables contain a column name 'FirstName' and...
how to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts - Hi All, I have one doubt in sql server . how to take Script database objects automaticaly using sql script and...
Import multiple excel files in one go - Hi all, i have around 50+ excel spreadsheets with 1 sheet in each, the same headings but varying amounts of data...
import .BCP files into sql server -
How to find the first recurring character of a string. - I have a query that finds the first recurring character in a string. For eg : if @str = 'ABCCDA' then i...
Excel 256 Column Layout - Hi IN a SSRS report when i am trying to export to excel it gives error since no of columns...
SQL versus program - Hi all, I'm posting my question in this 2008 forum because we're running SQLServer 2008R2, but it is more a general...
Join two tables with complex derived keys that don't match - Guys, I need to join two tables together - Master and Detail Master Table: ID =7000776601*1*6994 Code=P*W*S Instances=6994ý12510ý12874ý13245ý13609ý13973ý14337ý14701ý15009ý15072ý15436ý15800ý16164ý16528ý16899 Details Table
Msg 8152, Level 16, State 14, Line 7, String or binary data would be truncated. - I'm having a weird string truncation issue that we've fixed, but it driving me nuts and was hoping somebody may...
Dynamic variables in SQL server for HTML - I am trying to recreate and automated email. The email has gone from having, one column with headers and one...
Is there a user guide for blog content formatting? - The "powered by telligent" link at the bottom of the blog edit page goes to what appears to now be...
