Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
SQL Upgrade (From SQL 2014) Suggestions - Hello Folks, We are planning to virtualize for one of our SQL environments. As part of this project, we are planning to upgrade SQL as well. Current version/Ed is SQL 2014 Enterprise. Do you recommend to upgrade to SQL 2016 or SQL 2017 or SQL 2019? Please share your valuable thoughts... Thanks! |
Transactional Replication - Hi, I've setup some publications and subscriptions today and use a backup to start off the process ( init from backup ). Restored a backup to server Added in new subscriber using a backup file - it creates the subscription and SQL job etc ok no errors. But I just get this ( I've setup […] |
SQL Server 2016 - Administration |
SQL Server Sizing - I am trying to migrate Mysql Database which is hosted on Linux to SQL Server. So as starting point i am thinking to go with same configuration as Linux box(CPU, RAM etc). However, I agree with SQL Server we have (in memory tables etc). That would need more memory. But i was thinking do the […] |
Always on - I have question, i am configuring always on AG, so one of the replica would be used for reporting server(async mode). Looking at storage space, keeping the same space as primary replica would be good option, since primary replica server has only one DB and that would be used to replicate to the secondary replica? […] |
Newbie Q: Restore fails with "Database in use" - I'm apparently very late to the game here - I intermittently (reluctantly) end up becoming someone's DBA and used to use dbforums.com all the time - great community, lots of great help provided. Looks like that ship sailed a couple years back! Anybody know what happened to them? That crap site in place of it […] |
SQL Server 2016 - Development and T-SQL |
CHECKSUM(3) = CHECKSUM(-3) ??? - I am trying to use CHECKSUM() to streamline a WHERE clause that detects when a row in one table is different from a row in a second joined table. Today I was surprised to discover that changing the sign of a decimal value does NOT result in CHECKSUM() calculating a different value. DECLARE @SomeValue1 decimal(18,8) […] |
SQL 2012 - General |
SP Estimated Execution Plan - Please let me know your thoughts. FYI.. I removed the tb and Dbname. First question.. Attached is the screen shot of the SP for which I generated the estimated plan the steps I did to create the plan was USE DBNAME EXEC SPNAME – then right click on the code estimated plan. My only concern […] |
SSMS - Results Tab - Keyboard Shortcut - Greetings, In the results tab, is there a keyboard shortcut to copy a whole column of data starting from row number xx? I currently achieve this via another method by selecting a couple of cells in a column at the appropriate row number and then highlighting them by using shift and the mouse wheel. Ideal […] |
NEED HELP - Hi all I am so happy to be part of our community. Hope to be shared your tips, knowledge cos I am new Ths in advance ^^ |
SQL Server 2012 - T-SQL |
Minor code change will it make a difference. - Please let me know your thoughts on the below. Updated a small portion of the code. Just want to make sure it will give the same result. AND EXISTS (SELECT * FROM tbTask JOIN tbX_Dim_LatestVersion X ON X.X_ID = OD_X_ID AND X.X_Id = @X_ID WHERE Origin_ID = FI_ID) IS the below code does the […] |
SQL Server 2008 Administration |
How to upgrade to SP3 with multiple named 2008R2 instances on same server - I have a server with two named instances of 2008 R2, SP1. I have downloaded the upgrade executables from Microsoft to upgrade to SP3 and then do the Meltdown patch. Do I need to run each executable twice, one for each instance? If so, how? I tried looking for posts describing how to do this […] |
Upgrade from SP1 to SP3 on server with two named instances, run upgrade twice? - I have a server with 2008 R2 SP1 using two named instances. When I run the SP3 upgrade executable (SQLServer2008R2SP3-KB2979597-x64-ENU), do I run this once or twice (one for each instance)? I also realize that I need to run the Meltdown Patch executable, I presume also one time or two times? For my single instance […] |
Integration Services |
NULL(DT_DATE Variable in SSIS - i have a variable in my SSIS package called Name datatype value expression lastupdated datetime 12/30/1899 NULL(DT_DATE) My package has logic based on this date. if @[User::lastupdated] == (DT_Date) "12/30/1899" it goes to leftflow if @[User::lastupdated] ! = (DT_Date) "12/30/1899" it goes to rightflow. i am using this same variable form my dtsconfig […] |
Used Stored procedure in SSIS with different database name in DEV, Test and Prod - Hi, Can you please give me Idea, how can i use stored procedure in SSIS with different database name in Dev, Test and Prod ? In stored procedure, I am going to use source server as Phm_Dev ( Reading the data ) and load into Med_Dev (destination server) So when I move my SSIS In […] |
Unable to Open SSIS 2017 package - Hi, There are a couple of SSIS package (2017) version developed by another developer that are running flawlessly from the server. As the developer moved to a new role, he saved the packages in a folder in the server . I am unable to open those packages from the server. When i asked another […] |