I think that an example can show one aspect of the problem. Take a look at the code bellow. I'm not modifying the data, I'm just modifying the...

drew.allen (6/28/2016)

---

Since you are on SQL 2012, you should start using extended events. Using Profiler for traces has been deprecated.

First, you probably are not capturing all events, and you...

One option is to do it with CTE. In the CTE you define the 2 columns, and then in the select statement that uses the CTE you can use...

I think that it is a trivial plan. If I understand correctly (and I admit that that I might not understand it correctly:-D), a trivial plan is for queries...

Might not be the answer that you are looking for, but I do think that this might help you. I'm using the procedure sp_blocked_process_report_viewer that was written by Michael...

When you are doing a log backup, the size of the log file doesn't change. The log backup operation just clears some of the data in the log and...

Each locks uses memory, so the server sometime is doing lock escalation in order to use less locks and by that use less memory for locking. The lock escalation...

BrainDonor (12/7/2015)

---

I suspect that using the Czech character set requires that you use Unicode - NVarChar works fine, as does (on my machine)

SELECT * FROM @TESTTABLE WHERE KOD LIKE...

This is one way of doing it:

[Code]

SELECT DISTINCT T1.GoodId

FROM T1 INNER JOIN T1 AS T2 ON T1.GoodId = T2.GoodId

WHERE T1.LocNum = 500 AND T2.LocNum = 501

[/Code]

Adi

If what you are interested in is only performance, then I would suggest using sequence instead of identity and also use the return code or an output parameter in the...

You can do it with recursive CTE. Here is an example:

select * from myMenuCollection

declare @RecToDel int = 9;

With RecordsToDelete as (

SELECT menuCollection_idx

FROM dbo.myMenuCollection

WHERE menuCollection_idx = @RecToDel

UNION ALL

SELECT mMC.menuCollection_idx...

Creating big varying columns can also influence the amount of memory that the server will use for query. Each time the server runs a query, it needs to...

A short search on Google on the error that you got pointed me to this old thread - http://www.sqlservercentral.com/Forums/Topic767980-146-1.aspx which shows 2 possible solutions. Hope that it will help...

I would try running the command

exec sp_readerrorlog

In case that the bug is because of the GUI, it should work. If there is another problem, then you'll see the...

ChrisM@Work (8/5/2015)

---

s.chandrahasan (8/5/2015)

---

Hi , Thanks for you update.

I am looking for like a function to insert data like below instead of creating insert statement in your query.

select Name,Value1,Value2,Value3 from...