The most important thing is that you and your team understands the recovery procedures, so that in case of a disaster you can meet your RPO and RTO. That is,...

Yeah, given that it is not easily reproducible, and only appears in one specific context, I think opening a case with Microsoft is the right way. Particularly when you cannot...

Without a repro it is difficult to say what might be going on. There are no changes in this area that I know of. But check that the function is...

emiranda 59653 (8/1/2013)

---

I noticed that even after doing the DBCC Shrinkfile command, the files are still existing on the filesystem albeit they are all 0 bytes. I went ahead and...

As others have said, the presence/absence of the N determines the data of the literal. Try this:

SELECT '??fa', N'??fa'

As Jeff pointed out, you should not use nvarchar just to be...

Steven Willis (7/31/2013)

---

SELECT

Name

,(SELECT DISTINCT

COUNT(edh.BusinessEntityID) OVER (PARTITION BY edh.DepartmentID) AS TempCount

...

L' Eomot Inversé (2013-07-31)

---

I think that might depend on your auditing policy. Several logins might have the same capabilities, so map to the same usernames (using usernames to represent...

I...

I have never worked with SSAS, but as I recall when you install a Service Pack, there is a screen where you select which instances to upgrade. And since your...

If I...

If I remember correctly from a previous thread, your application is doing all this reindexing craze. Thus, you are in control. Make the reindex operation take out an exclusive application...

Running dynamically generated queries through OPENQUERY requires strict discipline in order to protect your mental health. Look at http://www.sommarskog.se/dynamic_sql.html#OPENQUERY for some tips.

I'm not really sure what your problem is. The query you posted would run on SQL 2008 R2, if you only have the tables. When I try I get:

Msg 208,...

Jack Corbett (7/31/2013)

---

I agree with Erland on this one. If the person(s) needs to be able to start/stop a specific job you would probably be better off...

Did you install a 64-bit version of the provider?

I have never worked with linked servers to Sybase myself, but I found this document which may be helpful.

(That text "this document"...