Viewing 15 posts - 3,451 through 3,465 (of 26,490 total)
That is if you are backing up the databases on the dev servers.
August 29, 2016 at 2:37 pm
Not really. Pretty vague on details so all you may get are wild shots in the dark.
Have you checked the SQL and system error logs to see if there...
August 29, 2016 at 12:31 pm
First, to clarify, you say this only happens on the mirrored instances of SQL Server, not the stand alone instances.
When you get these errors, has there been a failover from...
August 29, 2016 at 12:28 pm
I must be missing something. At first it was sounding as if you were getting the error on the SESSION table. Now, based on your latest post it is...
August 29, 2016 at 12:16 pm
From Books Online:
IDENT_CURRENT is similar to the SQL Server 2000 identity functions SCOPE_IDENTITY and @@IDENTITY. All three functions return last-generated identity values. However, the scope and session on which last...
August 29, 2016 at 9:53 am
jasona.work (8/29/2016)
Brandie Tarvin (8/29/2016)
Well my thought is that there are many people who are absolutely terrified of interviews, who don't see themselves doing well no matter what they actually know.
/Me...
August 29, 2016 at 8:57 am
TomThomson (8/26/2016)
The Dixie Flatline (8/25/2016)
They must be proud of their site. It helps unqualified people get jobs they can't handle.
I would have thought that that set of answers...
August 26, 2016 at 1:41 pm
Brandie Tarvin (8/26/2016)
Ray K (8/26/2016)
Eirikur Eiriksson (8/25/2016)
Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?😎
I'll...
August 26, 2016 at 12:27 pm
You know, it is really hard to offer assistance when we don't even see the whole query.
August 26, 2016 at 11:09 am
And what is this stored procedure expected to accomplish? A bit lean on the details.
August 25, 2016 at 3:54 pm
Sean Lange (8/25/2016)
Lynn Pettis (8/25/2016)
Actually, question 17 is correct. The default port for SQL Server is 1433.1 out of 38...sounds like a passing grade to me. 😛
For the coddled...
August 25, 2016 at 2:45 pm
Actually, question 17 is correct. The default port for SQL Server is 1433.
August 25, 2016 at 2:38 pm
GilaMonster (8/25/2016)
A few of them? I don't think a single one is correct.
I didn't make it through all of them so I couldn't speak to the ones I didn't read.
August 25, 2016 at 2:32 pm
Got to the following from a LinkedIn email. Not sure about a few of the answers.
https://intellipaat.com/interview-question/sql-interview-questions/
August 25, 2016 at 11:55 am
The values in sys.types show max length. VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) aren't different data types from VARCHAR(n), NVARCHAR(n), or VARBINARY(n) which is why you don't see the max_length of...
August 25, 2016 at 10:29 am
Viewing 15 posts - 3,451 through 3,465 (of 26,490 total)