Topics
Started by
Posts
Last post
Hi All, Will any index will be used if we use functions on a column referred in the where, what is …
4 replies
Hi All, Need some advice on this performance issues which is related to I/O. App team contact dba t…
3 replies
Hi All, Trying to delete rows from a table. it took 1 hour. It is deleting around 60K rows from 1 s…
6 replies
I'm using the StackOverflow 2010 database Posts table for this query. Why would it require 6 logic…
8 replies
My real example doesn't use orders or employees but I've adapted it to use this common nomenclature…
6 replies
Hi there I have the following code which has to extract an number from a AccountNumber variable dec…
13 replies
I have a Windows VPS where I am running a script with MSSQL database. In order to have a real time …
1 replies
We have a table where we keep rows with vanilla settings for products, and customized rows per prod…
16 replies
Happy to day to all, I am looking into an issue with a stored procedure where are where there are m…
3 replies
Hi, I have an application pushing data from source SQL database to an external SQL database. I have…
2 replies
Hi Everyone, The below update stmt is taking for 30 mins on PROD. would like to know from sq…
7 replies
I have table which has startdate which captures data every hour I need to get alert if startdate da…
1 replies
I have a table with a column that stores a set of sequential numbers and is an index with no duplic…
9 replies
Hi All, We have sql server instance running on a VM which hosts 5 small dbs. Now they wanted to mov…
6 replies
Hi, I'm trying to learn a bit more about SQLCMD mode in SSMS. I've got a script that runs a series…
1 replies
Viewing 15 topics - 1,381 through 1,395 (of 3,091 total)
You must be logged in to create new topics.