billp 37934 (10/5/2015)

---

I'm with Jeff on the header saying what the SQL is supposed to do. When debugging if a header says what it's supposed to do and the...

SQLRNNR (10/2/2015)

---

Brandie Tarvin (10/2/2015)

---

I found this StackOverflow article. Does it help?

DBCC SQLPERF('sys.dmv_name_here',CLEAR);

--EDIT: And then this if clearing plan cache too

DBCC...

WayneS (10/2/2015)

---

It seems that this would be a good time to explore locking down the production environment. Ideally, developers have no need to access production. They might need periodic access...

brad_bowzer (10/2/2015)

---

I wrote a system in MS access in 1993 and upsized it to SQL Server in 1996. Its been updated constantly but the core is much the same...

Iwas Bornready (9/30/2015)

---

I develop code in a fashion similar to what you have stated. I also find that expectations change as we develop, especially when we start showing the results...

Iwas Bornready (10/1/2015)

---

It sounds good, and may be good. It certainly must be for you. But I have a set amount of work that needs to get done. How do...

Brad Allison (10/1/2015)

---

This is great advice that I will share with my small team of SQL Server developers I work with. I usually give them some daily technical inspiration...

Tepluken (10/1/2015)

---

Terrific advice. I always take a walk at the end of the day. Usually I will listen to a podcast as I walk to pass the time; however once...

I do usually tell people in Scouts or kids sports that I'm a computer guy. If they know something and want to ask more, I will talk about databases.

I'm not clear what you are seeing here.

You can connect with SSMS. What are the credentials?

In Data Tools, do you mean SQL Server Data Tools? SSDT? Can you enter the...

Apart from what has been suggested, I try to solve things like this for one area. Write down the plan for one dimension or entity and solve each one. Then...

Watch target memory for each server, and try to balance the load. It's up to you to somehow set this between instances.

Can you connect with localhost or .?

Indeed we have.

That's why I've typically called myself the data janitor.

You need something like this:

SELECT

'SQLAgent - TSQL JobStep (Job 0x'+

CONVERT(char(32),CAST(j.job_id AS binary(16)),2) +

' : Step ' +

CAST(js.step_id AS VARCHAR(3)) +

')', j.job_id, j.name

FROM msdb.dbo.sysjobs...