Viewing 15 posts - 976 through 990 (of 1,219 total)
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,...
August 2, 2013 at 1:26 am
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...
August 2, 2013 at 1:11 am
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...
August 1, 2013 at 4:15 pm
emiranda 59653 (8/1/2013)
August 1, 2013 at 4:04 pm
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...
August 1, 2013 at 7:33 am
Steven Willis (7/31/2013)
Name
,(SELECT DISTINCT
COUNT(edh.BusinessEntityID) OVER (PARTITION BY edh.DepartmentID) AS TempCount
...
August 1, 2013 at 1:31 am
L' Eomot Inversé (2013-07-31)
August 1, 2013 at 1:28 am
Grant Fritchey (7/31/2013)
So much for my stupid Cartesian product statement. You do have that problem. First warning right at the top of the plan indicates you don't have JOIN criteria.
I...
July 31, 2013 at 4:15 pm
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...
July 31, 2013 at 3:55 pm
bonifacy (7/31/2013)
Ok, sorry for my english.I created new user by syntax: ( create user TestUser for login TestLogin ) How I can use this user in SQL Server Authentication?
If I...
July 31, 2013 at 3:44 pm
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...
July 31, 2013 at 3:39 pm
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.
July 31, 2013 at 3:34 pm
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,...
July 31, 2013 at 3:32 pm
Jack Corbett (7/31/2013)
July 31, 2013 at 12:58 pm
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"...
July 31, 2013 at 12:55 pm
Viewing 15 posts - 976 through 990 (of 1,219 total)