Topics
Started by
Posts
Last post
Just moved from learning mysql to SQL Server 2012, and already having an issue. Here is my code: CR…
13 replies
I have tried pivoting - no success since the numbers of rows in the source table that have to tacke…
7 replies
I was asked to look at a query today that was taking a very long time to return. I waited 10 minute…
16 replies
Hi All, I have a table with more than 50 Million records. I am changing a PK column into …
2 replies
Hi All, I have attached two queries with table definition and sample data. Query 2 is working bette…
13 replies
Hi, I have a query which is using left outer join. Query should execute in seconds instead it is …
1 replies
I would like to create a linked server with the name "Production" that points to an IP address&…
6 replies
Hi, I have a SQL Table in the below structure and am trying to write a PIVOT Query to get the %cont…
10 replies
Hi, I have a field that contains some XML. The root level is ENTITIES there might be many ENTITY no…
2 replies
Hi everybody, I struggled with a bulk insert in procedure and i eventually found a working piece o…
3 replies
Hi All, This query is running slow due to a TABLE VALUED function in select clause. Definition…
9 replies
Dear All, I have got a small query for optimization and I need your help in it. It is taking 7…
6 replies
Can someone explain why @p2 is null/empty? begin try drop procedure TestOut end try begin catch end…
3 replies
Can you tell me what could be wrong with my SP? I'm using Merge and I'm new to it. What i was hopi…
8 replies
Hi, I am building a powershell script that has a GUI interface for a 2008R2 cluster with SQL 2012 A…
2 replies
Viewing 15 topics - 4,846 through 4,860 (of 4,984 total)
You must be logged in to create new topics.