djj (2/16/2016)

---

Alan.B (2/16/2016)

---

Lynn Pettis (2/16/2016)

---

The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants...

I noticed that too (and...

Note the section titled "Using Transact-SQL" in this link: Enable Compression on a Table or Index

If there is a possibility that OccurrenceTypeName will contain any of what SQL Server considers XML characters (e.g. CHAR(1) through CHAR(32), CHAR(38), CHAR(60) or CHAR(62)) then you would make a...

There is no reason you should need a cursor here or any other form of RBAR solution for this. Based on a quick look at what you're trying to do...

Why do you think you need any index on the...

EasyBoy (2/16/2016)

---

We have few (2-3) reports which are run by users through application everyday in the morning.

Through SQL profiler i found those queries (dynamic SQL), which are running through SQL...

Huh?!?! I just thought my SSC paycheck was really late. Aw man!

Lynn Pettis (2/16/2016)

---

The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants of the...

Luis Cazares (2/16/2016)

---

For this particular case, there's a simpler solution using common date routines[/url]

SELECT

StartTime = DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), -.25), -- 6PM yesterday

EndTime ...

I prefer to use T-SQL for this type of thing. The way I would do this is:

1) Create a Dataset named something like DS_DateDefaults (use whatever matches your naming convention)

2)...

Interesting article. Well done sir.

For those of you who are into quantum mechanics...

IT'S OFFICIAL: Gravitational waves have been detected, Einstein was right

Microsoft actually allows you to chat with their licensing specialists online. It's been a few years but I have used this service and found them quite helpful.

http://blogs.technet.com/b/volume-licensing/archive/2011/11/23/click-to-chat-now-on-microsoft-com-licensing.aspx

During some tough projects I...