Hi Ya Ten Centuries.

Unfortunately it is a complex process. As I mentioned in another reply the patch came down with Windows Updates. It is very time consuming to...

A point to be aware of.

The "fix" will download as part of Windows Updates.

I usually download Windows updates automatically to Dev servers but I apply the update package manually then...

Konstantin Rudoy (6/2/2015)

---

For 15 years I was against splitting the code into the parts until started working with hundreds of millions of the records. And what is the interesting part,...

Here are a couple of things to consider.

When SQL2005 introduced VarChar(max) I encouraged Devs to adopt the new data type immediately and most did. Eventually, we decided to script...

You are correct. I was, at best, imprecise in my language. I did say that the Date and Time are integers but I certainly confused things by mentioning...

I think we see a common misunderstanding illustrated here.

We think of and represent DateTime as a string and SSMS (and most other providers) obligingly display the value as a string....

Early in the script (about line 5) you set ToFileOnly = True. Then about 3 lines from the bottom you set the option to False.

is there a reason for...

Hi,

The easiest way to do this type of migration is Backup old DB, Copy Backup to new server, Restore on new server.

It is a simple process but there are...

Hi All,

Thanks for the many responses. I am surprised that so many of you stayed nearly on topic.

I would like to make a few general observations and comments but...

You did not provide any environmental info (Windows version/Edition, etc.) but assuming the server name and so forth are correct then the issue is almost certainly with file and share...

Thanks Gail,

If I understand it correctly then I could see many Context Ids associated with a Session Id but I should never see more than 4 Scheduler Ids at any...

Sorry I thought the results table was formatted but I guess I messed it up.

The columns are:

1. - SPID

2. - DB Id

3. - Task State

4. - Task Pending I/O

5....

The direction of the discussion has strayed a little bit from the original topic:-P

The behavior you guys are discussing is not specific to Views. it is general behavior of...

enriarg (4/3/2014)

---

Also as a post done here about 4-5 months ago they cover partitioned views, which as Jay posted contradicts the post you have done about querie all tables on...

While the April Fool's joke is great the sentiment behind it is very serious. IMHO Microsoft is driving away SMB in a number of ways.

In my case we have...