SSMS 2017 v3 - files open disconnected, no connection option - Maybe I am just missing something, but when I double-click on a .sql file, it opens connected, or at least...
FAST_FORWARD cursor slow for simple SELECT COUNT(*) because sp_cursorfetch() re-scans all index - Hi all, We are using MS ODBC 13 (on Linux) to execute a simple SELECT COUNT(*) FROM table query... This query is...
Agent Job fails on "sa" account login - I have a couple of SQL Server Agent jobs configured to run as "sa" However, they fail with the error "Description:...
SQL Server 2016 : Change compatibility level after migration - Dear all, I have migrated my SQL Server from SQL Server 2012 to 2016. Not I have the followinf list of...
Replicate data from PROD into test - Dear all, We need to replicate our database from PROD into Test environment as we should have a copy of PROD...
Slow query - client or server issue - If seeing a client make a regular query that uses the same plan but completes in radically different times on...
SSIS reading data from a view. - I have recently encountered this problem wherein when I am trying to load data from a view(view has join on...
Sorting after records deleted - CREATE
Using CSS to control formatting in dbmail - I have written a query and currently have a job that runs and sends an email using sp_send_dbmail in a...
Bulk insert into table from csv - Hi, i have table in CSV: As you can see there are a lot of columns. My source table data types fields are:
Transfer Database Data - hello community. i have two databases. one is old version and other is new version .. in new version i have some...
Did anybody have this problem - I have simple query: SELECT (select ISNULL(SUM(TOTAL_PAYMENTS),0) from Orders where ST_ID IN(SELECT ID FROM Name where CO_ID = 11750) and ORDER_DATE...
Tempdb Error - Hi All, I have 3 ndf files for Tempdb and each one is now grown to 110+ GB. i.e total 330...
Query working differently on different servers - Hi - I've got a development server where my T-SQL code is working fine, but when I port it to my...
Transaction log issue - HI All I have a repeat incident in my database server Transaction log is getting full pretty quickly and fill up...
Problem with SQL Stored Procedure - I'm not sure what the best way is to present this issue so please forgive me if I fall short...
Convert sys.master_files size column to GB? - How can I Convert sys.master_files size column to GB? Select db_name(mf.database_id) As DatabaseName , convert(int , Case When convert(bigint , sum(mf.size)) >= 268435456 Then...
Job getting stuck in UAT but runs fine in Prod - Good Morning ExpertsOne of our jobs is getting stuck everytime it is triggered in UAT. The same ,job is running...
Mathematics/Algorithms in SQL - All, I am looking for some article which explain what are all the mathematics concepts and algorithms used in SQL.
info using sysarticles and syspublications - Is there a way to get the below information by joining sysarticles and syspublications Get Transactional replication details (publisher name, Publication,...