|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Checking the Sequence | |
If I want to get the next value that will be returned for a sequence object, called MySequence, what query should I run? | |
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) |
Azure MariaDB Which compatible Azure database service would you use for a MondoDB workload? Answer: Azure CosmosDB Explanation: The Azure CosmosDB service is compatible with MongoDB. Ref: Azure Database Products - https://azure.microsoft.com/en-us/product-categories/databases/ |
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 |
T-SQL Error: Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '('. - I could use some help figuring why this use of CONVERT isn't working as expected. --T-SQL Code: 1 SET nocount ON 2 DECLARE @JobName sysname 3 SELECT @JobName = [name] FROM msdb.dbo.sysjobs 4 WHERE Job_id = CONVERT(uniqueidentifier, $(ESCAPE_NONE(JOBID))) 5 PRINT '>'+@JobName+'<' --Error: Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '('. --SQL […] |
SQL Server 2016 - Administration |
Change tracking disabled but auto cleanup running anyway - I recently noticed in the logs of one of my 2016 servers that the Change Tracking manual cleanup procedure is running for all databases. I have checked the databases and change tracking is off for all of the databases. sys.change_tracking_databases and sys.change_tracking_tables are both empty I tried to just disable the auto cleanup but get […] |
Using EE to trace the code generated by an app - Hi all, We have an app that currently requires Admins /Power users to navigate a difficult GUI, but clearly it's sending SQL to the DB. A first look at the underlying table shows the column names map perfectly to the fields in the form, but of course the table has multiple dependencies, so I'm hoping […] |
SQL Server 2016 - Development and T-SQL |
help with case statement - Hi I need help with the SQL query.. requirement is that wherever flag is null and room_cd is single for room then it should be labelled as Any_empty and if room_cd is multiple for room then it should be labelled as M_empty or F_empty depends on the majority of flag in room. like in room […] |
Development - SQL Server 2014 |
Query - Hi I have below data and i want if both Sale & Purchase = 'N' then that record should not be displayed Item Name Purchase Sale 1 AB Y N 2 BC N […] |
Month Name - Hi How to get Month Name from Date field Thanks |
SQL Server 2019 - Development |
Query Run Time - Hi everyone The query I am working on seems slow to me. The table has about 600 records and the query takes about 15 seconds to run. I put on statistics and here is what I get. I don't know how to interpret this. Are the stats showing what I am seeing? I took a […] |
How to create a 2nd temp table in SQL - I have such a situation. I basically need to put my whole code into a second temp table(?) to be able to select from it. The code inside works just fine I just cannot understand how to basically create a bigger temp table that will absorb the first one and the previous select and later […] |
Issue with NULL not allowing a calculation to happen - I have such a situation I use this command to basically allow division by 0. So far it was working just fine, but now it for some reason no longer works well for me. SET ARITHABORT OFF SET ANSI_WARNINGS OFF I am trying just to make a simple calculation like this sk.OH + […] |
Arithmetic overflow error converting expression to data type smallint - Hi everyone I am getting error Arithmetic overflow error converting expression to data type smallint The calculation I am doing is producing very small numbers like 0.0000005328. How can I fix the calculation so it produces correctly? I am guessing I have to typecast the calculation so it works properly because smallint is definitely wrong. […] |
SQL Azure - Development |
Getting error 64 when trying to connect to the AdventureWorksLT database - A couple of weeks ago I asked here how to get a sample database into Azure SQL. I got great feedback and was able to get the AdventureWorksLT database into Azure SQL. However, as often happens where I work, I was pulled away to work on other, urgent, tasks. So, I'm only now able […] |
Reporting Services |
Production setup of SSRS - I'm learning SSRS at this time - I have a SQL Server developer edition, SSRS service and Report Builder installed all in a same VM running on my laptop. I'm trying to figure out what's the best practice setup for production scenarios? I figured the Reporting services will be installed on a web server, which, […] |
Powershell |
invoke-sqlcmd : Cannot open database requested by the login. login. Login failed - Hello, I am not able to figure out why invoke-sqlcmd is not working. It’s giving login failed error..This user has sysadmin permissions. When the azure release pipeline runs, if the database does not exist then it restores the new database from the .bak file....and i am using invoke-sqlcmd command for that......when i try to run […] |
SQLServerCentral.com Website Issues |
Emails from forum posts aren't going to the post - I've noticed that the emails about forum posts I've been getting from SQLServerControl.com the last week or so, no longer point to the post in the forum. I just wanted to mention this. |
Job Postings |
HIRING: Data Warehouse Developer at Center for American Progress - Reports to: Senior Director, Enterprise Systems and Procurement Staff reporting to this position: None Department: Technology Position Classification: Exempt, full time; Nonunion - Level 6 Minimum compensation: $75,000 Summary The Data Warehouse Developer will deliver integration solutions to American Progress. The position will focus on automating integrations between various business systems, including Unanet, Paycom, Salesforce, data services, and data warehouse […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |