|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
CLOSEing a cursor | |
What does the CLOSE command do to a cursor? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Sending Your Local Branch Up I clone a Git repository and am on the main branch. I have created a new branch in Git with this code: git branch featureSteve I now add some code to the repo and commit it. However, I've made a mistake. What is it?
Answer: I didn't checkout the branch Explanation: Using git branch will create a branch, but it does not checkout the branch for work. You need to use "git checkout featureSteve" before adding code. Ref:
|
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
DBCC CHECKTABLE Errors - Hi all, Please see attached for the output of DBCC CHECKTABLE on one of our tables. The affected records are almost certainly attachments we are storing as VARBINARY in the table. I'd like to know what my options are. Restoring to a previous backup is unfortunately not possible. I am okay with repairing with data […] |
Exec SSIS package from TSQL Agent Job Step - Hello, I have a SSIS Package deployed to the SSISDB Catalog. I have a stored procedure setup to create an execution, pass in a few variables/parameters and then start the execution. I created a tsql jobstep to call the stored procedure. This works as long as the agent job is owned by an SA user. […] |
SQL Server 2016 - Administration |
ETL Tool job is slow - Hi Experts, I need some piece of advice on how to about this below scenario. In our environment we have ETL solution called BODS to load data into a datawarehouse. Application team says, one of the ETL job is running slow. Basically, it is not a SQL Agent Job. ETL tool has its own job […] |
SQL Server 2016 - Development and T-SQL |
Script for employees and their monthly man hours - Dear Everyone I hope you are all safe I have a script which needs to be modified for gathering the monthly man hours for my company. I use a cursor to add the employee ID and man hours into the cursor and display it at the end of the cursor. I cant get to display […] |
Administration - SQL Server 2014 |
shrinking data file - Hello all, I am struggling with shrinking of a big database in TB. I read on many links and it is recommended not to shrink the file because it may cause defragmantation. In my case it is absolutely needed. I went through this article and did some shrinking on some dev DB and it worked […] |
Development - SQL Server 2014 |
T-SQL Query select with a heap table without join - Hi, i have a query for selecting data on multi tables with a join but one of my tables is a heap table with million rows without join (no clustered index and no non_clustered index) performance is very bad, do you have an idea to perform? |
SQL Server DLLs required on user's PC - Hi, I have deployed my program on several user's PCs and they get the following error I believe when the program tries to Open a connection: "Login filed for user". Kind of a strange error., since the credentials are in the program and I don't get the error when I run from my PC, but […] |
SQL 2012 - General |
At wits end with Service Master Key, please help. - Recently our linked servers are failing due to the following "Generic failure...Service Master Key..." So knowing what I know I need to regenerate the Service Master Key using: ALTER SERVICE MASTER KEY FORCE REGENERATE Which I get the following: The current master key cannot be decrypted. The error was ignored because the FORCE option was […] |
SQL Server 2019 - Administration |
I have 4 nodes and i want 3 instances on 3 nodes and 4th as passive for windows - I have 4 nodes and i want 3 instances on 3 nodes and 4th as passive for windows fail over cluster i am not sure what should be ideal architecture and how to proceed with further any one has detailed idea and if can help me would be greatful |
Does Migration assistant support SSRS - I see the migration assistant tool has support for database engine and SSIS, but I don't see SSRS, So no support for SSRS? Thanks |
Encryption key for SSRS - do I need to restore or not? - Encryption key - do I need to restore it or not ? I am testing some SSRS migration process. I noticed if I migrate from a server to a different server, I do need to restore encryption key after restore the report dbs. But if I just change an existing server from one name to […] |
SQL Server 2019 - Development |
Failed to Initialized SQL CMD Library? - Hello~ I have a scheduled SSMS Job that had been working without issue, but started failing recently with the following error: Message Executed as user: NT AUTHORITY\SYSTEM. Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE 42000] (Error 22050). The step failed. The job is simply running a T-SQL script that counts the number […] |
Decimal places - Another decimal question re decimal points within a case statement. Trying to get 2 decimal points for each case statement but not getting the results expected. Thanks for any help. select f.Month ,f.Site ,ISNULL(f.num,0) as 'NUM' ,f.DEN ,case when f.HAI ='A' then (isnull(f.NUM,0)/f.DEN) *10000 when f.HAI ='B' then (isnull(f.NUM,0)/f.den) *1000 when f.HAI ='C' then (isnull(f.NUM,0)/f.den) […] |
is value is contained in column - new column - i need to add a column to determine if ID and specified Type exist in the table (1 if exists, 0 if not) Specific Type: B ID Type Desired Column 1 A 1 1 B 1 2 A […] |
Anything that is NOT about SQL! |
SSC Fantasy Football 2021 - Placeholder for the 2021 league. Congrats to the 2020 winners: First - Way0utwest Cowboys - $100 Second - British Bulldogs - $75 Third - SSC Ravens - $50 I'll do the same prizes next year. Everyone from 2019 has first crack at the league (12 teams), but if you're interested in joining, leave a note […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |