Topics
Started by
Posts
Last post
We are in the process of moving about 20 databases to a new data center. As part of that move, we w…
3 replies
Hi all - the last couple days one of my SQL Server 2008r2 has been getting hammered by messages l…
4 replies
Hi all, Not really sure if this is the appropriate forum for this question; if not, please redirect…
2 replies
Our devs have an application which is performing a large query on the database. It is taking over …
4 replies
Hi, I need the exact Data Type Mapping for DECIMAL(65,2) MySQL to SQL SERVER. What data type shoul…
10 replies
Hi, I'm trying to make a query that does a dynamic pivot on the date field. I would like a new date…
13 replies
CREATE TABLE #tblLeaders ( LeaderID int, Leader varchar(50) ); INSE…
6 replies
I am running a query on SQL 2012 Server with the Resource governer setup for my account to have Max…
1 replies
I have a query that run in 3 seconds when executed with hint OPTION (MAXDOP 1), but the same query …
3 replies
Hi all, Today, I have found a situation like the below. Table has zero rows but when i have run sp_…
11 replies
Hi All Is there a way to see what is the IO load put by a particular DB on a given instance? I am n…
1 replies
Can someone help me please with this request: SET @sql = 'SELECT *,''A'' FROM OPENQUERY(' + @VALE…
3 replies
I am seeing the Sch-S + Sch-M deadlocks on our system. They occur because the maintenance online in…
4 replies
Hi trying to add a case statement to below so when enddate is null then use getdate() Thanks Joe D…
3 replies
Hi! I want to ask about creating a secondary or standby Database server. I do have two DB server, r…
6 replies
Viewing 15 topics - 6,721 through 6,735 (of 30,225 total)
You must be logged in to create new topics.