Empire

SSRS is meant for "static" reports. Something that will be shown always as defined. It's great for reports that should be printed. It usually requires some technical skill when modifying...

You would get better help about licensing if you contact Microsoft directly. Anything said in this forum would be unofficial and possibly different from the real options you have.

I wouldn't want to keep that. I might actually use it for...

Sioban Krzywicki (4/29/2016)

---

Eric M Russell (4/29/2016)

---

If you really want, you can also model an entire database containing objects with only spaces for names.

create database [ ];

GO

use [ ];

GO

create...

There's no need to create a view from SSRS. A view is simply a named query. You should be creating a stored procedure in the server and call the stored...

ntext doesn't have a length definition. It has a predefined maximum size.

You should stop using ntext and start using nvarchar(max). It has the same capabilities and it's easier to manage....

CAPS lock is affected system wide, so the indicator in the keyboard should be enough.

If there's no indicator in the keyboard, there's usually an icon next to the clock.

Why would...

I've found this tool very useful.

http://www.red-gate.com/products/sql-development/sql-search/

(I don't work for Red-Gate)

You would need to be specific on what you need. Design? Monitoring? Automation?

You need to comment all tables and the uncomment each table at a time. Or go the other way, comment one table at a time and see which one would...

Something like this?

SELECT DISTINCT

CASE WHEN MAX(Criteria) OVER( PARTITION BY ServiceName) <> MIN(Criteria) OVER( PARTITION BY ServiceName)

...

Review which table is causing the dupes and remove them there before doing the join. In other words, use a subquery or temp table if necessary.

Check Date is the same...

Brandie Tarvin (4/29/2016)

---

Grant Fritchey (4/29/2016)

---

Brandie Tarvin (4/29/2016)

---

So a coworker attended a gender diversity workshop. She forwarded me the presentation with a slide that says women constitute 40% of database administrators,...

Change the IN for an EXISTS clause.

select FKStoreId, DateOfBusiness, CheckNumber, COUNT(fkitemid)

from dpvHstGndItem o

where EXISTS (

select 1

from dpvHstGndItem i

where FKItemId = 200112

and DateOfBusiness = '2016-04-01'

AND i.CheckNumber...