sqlserverDBA2016 (11/5/2016)

---

I have 40 databases on a single sql server instance

I wanna move them to 2 new data and log directories

Using backup and restore but would like to keep the...

juniorDBA13 (11/7/2016)

---

I won't be changing the data that will be moved.

It will be just a straight copy from SQL Server to a single source.

It will be just a copy of...

Question, do you see the trigger in sys.triggers?

😎

SELECT

OBJECT_NAME(STRG.parent_id) AS TABLE_NAME

,STRG.name ...

abhas (11/7/2016)

---

Thanks Eirikur and Jeff.

Now again requirement has changed. Now instead of increment, new logic is as below:

First letter of firstname + LastName.

If username alreadu exists then create as:

First ...

alfred.h.hernandez (11/7/2016)

---

When I run that query and display the results as text I goes on and on for over a minute, then I stopped. Displaying over 40K rows.

If I run...

Deny Christian (11/7/2016)

---

hi All,

I have a Supplier data :

COMPARE:

SERVER A : V, ...

alfred.h.hernandez (11/7/2016)

---

Thank you for your reply!

Unfortunally I can't see wierd with memory och I/O.

But I just saw that if I display the results to text instead of grid there is...

Don Halloran (11/6/2016)

---

I've used extended events sparingly for admin purposes, but never as a normal developer resource. I wasn't even aware there was a "data change" type of extended event...

Quick suggestion that concatenates all step messages into a single column

😎

SELECT

sj.name

,sj.enabled

,STUFF(

(

...

For fun, here is an alternative method

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(CID,C1,C2,C3) AS

( SELECT CID,C1,C2,C3

FROM (VALUES

(1,'aa', '100', 'vv')

...

Have you looked into using Extended Events for i.e. triggering a poll etc.?

😎

sqlfriends (11/4/2016)

---

I have a productCase table that we created cases for some products. Then there are some other tables related with this productCase table such as productCaseNotes, ProductCaseNotifications etc.

I would...

Forgot to mention the MSDN online tutorials Tabular Modeling (Adventure Works Tutorial)

😎

berryber (11/5/2016)

---

Normally, googling and messing around, solves 99.999% of my IT (or relationship) problems. This one however, is giving me massive headaches.

Situation:

I have a package which runs over a selection...

alfred.h.hernandez (11/6/2016)

---

Hi,

I recently discovered that when I query a table (anyone I've tested) and the results are more than 1000 rows, Management Studio keeps hanging/lagging.

The more rows the result shows...