Topics
Started by
Posts
Last post
Hi all, I have a job that runs twice a day, sometimes it fails due to some bad files received. I wi…
2 replies
We are running SQL2008R2 in a production application. VM Ware, 4CPU, 6GB memory. Performance is a…
8 replies
So I have the following code below and I am getting the following error: Msg 102, Level 15, State 1…
3 replies
Hi All , I have a deadlock in my system and am suspicious about index defragmentation that I run a…
12 replies
Can somebody check my naming convention and see what am I doing wrong here: ,(Select Count(C2.AppID…
23 replies
I have similar task to previous post i have client table which has client_id Eff_from and Eff_to co…
3 replies
I have a challenge and I'm not sure the best route to go. Consider the following dataset. I have a…
6 replies
I've never worked with the XML data type in SQL Server, although I know its been there for a few it…
5 replies
when prod db is restored in test server, i have to hide/replace sensitive fields (name, phone etc) …
5 replies
I have a XML data passed on to the stored proc in the following format, and within the stored proc …
6 replies
Hi, I want to convert table into following xml format. Sample two records is given below. Any help …
20 replies
How to call database from another server while trying to set up a job on the reports server. I curr…
8 replies
I have a SQL Server 2008R2 SP2 where a NOLOCK query is blocking an update of a different record. I…
Anonymous
15 replies
Hi, Could someone help me with sql code for the following? (SQL Server 2008 R2 - SQL Server 2012) I…
1 replies
What is a good way to get a SQL Server 2008 R2 Database Dictionary?
5 replies
Viewing 15 topics - 3,211 through 3,225 (of 30,224 total)
You must be logged in to create new topics.