Viewing 15 posts - 121 through 135 (of 617 total)
GilaMonster (9/26/2012)
Half my clients are still running SQL 2005. The rest 2008 or 2008 R2. I might get one 2012 upgrade done this year.
Lucky. We are struggling to get...
September 26, 2012 at 8:27 am
Forget it. I found the answer here:
Turns out if you have an instance on a cluster that is not using port 1433 you have to set up a local...
September 25, 2012 at 10:25 pm
I finally found an error but I have no idea what to do with it. In the server application errors I'm seeing:
There was an error on the connection. Reason:...
September 25, 2012 at 10:20 pm
Take the exams. At the very least they allow you to do the upgrade path for the MCSE and MCSA in 2012. That saves you one exam for...
September 25, 2012 at 10:08 pm
Exchange is only used in SQLMail right? And to my knowledge the SMTP server is open to everything in our domain.
September 25, 2012 at 7:16 am
Just out of curiosity give this a try:
CREATE LOGIN [ABC.COM]\ABC105$ FROM WINDOWS WITH DEFAULT_DATABASE=[master]
September 19, 2012 at 11:03 pm
Miles Neale (9/19/2012)
joe.wolfe (9/13/2012)
September 19, 2012 at 9:22 pm
Nils Gustav Stråbø (9/19/2012)
Bummer. Missed the TOP 1.Always. Read. The. Full. Question.
+1
sknox (9/19/2012)
Even if you know TABLESAMPLE inside and...
September 19, 2012 at 10:58 am
lanre_makinde (9/19/2012)
Sorry i disagree with the answer, unless there is an explanation for "NotGo"
You can read the discussion or the answer explination but here is a quick go at it....
September 19, 2012 at 10:11 am
Look into Expressions. They will do exactly what you need. Select your connection manager and about half way down the list of properties you will see "Expressions". ...
September 18, 2012 at 8:21 pm
Personally I like the certification route. Even if you don't actually take the tests (and the 2008 exams will no longer be given after the middle of next year)...
September 18, 2012 at 8:13 pm
mpartridge (9/18/2012)
I manage an environment where all developers are given db_owner access to their databases. I have a schema called app in these databases which is linked to the role...
September 18, 2012 at 8:05 pm
GilaMonster (9/17/2012)
Are they object plans (procedure, trigger, function), parametrised or ad-hoc queries?
It appears to be a fairly even mix of all of the above.
I did do some playing...
September 18, 2012 at 1:36 pm
Charles Kincaid (9/18/2012)
DB.Duck (9/17/2012)
CELKO (9/9/2012)
...we do not use BIT flags in SQL...You, sir, couldn't be more wrong. That is all.
Actually it's almost a great point but poorly stated. Let...
September 18, 2012 at 8:11 am
vsarade (9/18/2012)
SELECT Professor.Id AS [Professor.Id], Professor.ProfessorName,
CASE Professor.HasTenure WHEN 1...
September 18, 2012 at 7:43 am
Viewing 15 posts - 121 through 135 (of 617 total)