Viewing 15 posts - 61 through 75 (of 1,162 total)
This isn't what you're seeing is it?
http://sqlblog.com/blogs/merrill_aldrich/archive/2013/03/15/ssms-2012-restore-gui-gotcha.aspx
February 17, 2014 at 10:23 am
From the IP in the screenshot, it looks like you're trying to enable external connections directly to SQL over port 1433 (e.g. over the internet rather than just LAN). This...
February 14, 2014 at 6:29 am
Yeah, I have seen this before.
If you're doing a new migration to SQL 2012, I'd strongly recommend going straight up to the latest Cumulative Update if your policies allow...
February 7, 2014 at 9:49 am
L' Eomot Inversé (2/3/2014)
February 4, 2014 at 2:39 am
Jeff Moden (2/3/2014) One other problem that I have with them is that people think they're still "Globally Unique" and they haven't been since MS changed them from Type 1...
February 3, 2014 at 8:55 am
michael.mcloughlin (1/31/2014)
I have upped the session time-out to 15 seconds, i assume this is just a standard ping?Will see how it goes over the weekend.
Careful with that, it really depends...
January 31, 2014 at 5:05 am
Jeff Moden (1/30/2014)
rodjkidd (1/30/2014)
... {snip}...
Went to talk to one of the Prod DBA's as my access on the server is limited, and he spots that the server...
January 30, 2014 at 8:10 am
Does the SQL error log on the secondary show any I/O errors during the time of the snapshot? Anything else of interest in the error log at the time of...
January 30, 2014 at 6:56 am
If this is in sync mode, then it sounds like the replica's failing to respond to a ping within the configured session timeout, so it's dropping out of sync rather...
January 30, 2014 at 6:23 am
Lynn Pettis (1/24/2014)
Has anyone else ever heard that it is a best practice to have enough server memory to hold your entire database in memory?
No, but I've heard plenty of...
January 24, 2014 at 9:42 am
GilaMonster (1/23/2014)
Whoops... http://www.sqlservercentral.com/Forums/Topic1533954-391-1.aspxAnyone with TDE experience that can assist?
Shame on Microsoft for not providing a way of unencrypting an encrypted database without the key.
January 23, 2014 at 4:21 am
Do you have any triggers defined on the table? As Lynn says, the SQL posted will work fine against the table as it's defined above.
December 19, 2013 at 9:40 am
I've never used RAC on Windows, but assuming it's similar to Linux, I think it tries something graceful first, then Clusterware relieves it of its storage layer after a timeout...
December 11, 2013 at 6:44 am
If the only attribute you're interested in is whether the customer is billable or not, then a degenerate dimension straight off the fact is probably all that's required and you...
December 10, 2013 at 4:46 am
Lynn Pettis (12/4/2013)
HowardW (12/4/2013)
Lynn Pettis (12/4/2013)
Just a quick question, does anyone know what port(s) SQL Server uses for its Linked Servers?
Whichever port the remote instance is listening on, it's just...
December 4, 2013 at 10:27 am
Viewing 15 posts - 61 through 75 (of 1,162 total)