Viewing 15 posts - 136 through 150 (of 617 total)
asifkareem (9/17/2012)
i thing on that side the...
September 17, 2012 at 2:56 pm
Sqlism (9/14/2012)
In one of our server we are not using ssis ssrs ssas at all. but i see Report Server and Report Server tempdb online. Does keeping these database...
September 14, 2012 at 9:14 pm
I'm going to make a couple of educated guesses and if anyone call tell me if they are flat out wrong or can prove them I would appreciate it.
I can...
September 14, 2012 at 9:11 pm
SQL Kiwi (9/14/2012)
Peter Brinkhaus (9/14/2012)
Looking at the syntax definition of the FROM clause the binding error makes perfect sense.That does make sense, thanks!
+1
I had been guessing that was the case...
September 14, 2012 at 9:00 pm
Artur Komkov (9/14/2012)
Question itself is not clear and right answer is definitely "false". It is a disaster to have an interview with...
September 14, 2012 at 2:48 pm
sestell1 (9/11/2012)
Great question Ravi, thanks!Interesting note about traceflag 610 SQL Kiwi, I was not familiar with that traceflag.
Here is some more information on it:
http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx
EDIT - fixed a typo
+1
September 13, 2012 at 9:04 am
FYI In case anyone is interested you can change the batch seperator (and other settings) on a single query window by right clicking on the window and going to "Query...
September 13, 2012 at 8:56 am
Sean Lange (9/13/2012)
For everybody who seems to be hung on the verbiage I can only say "GET OVER IT". English is not the native tongue of everybody on this...
September 13, 2012 at 8:31 am
pg53 (9/12/2012)
Just to pick up on this point you made:
"We" do use BITs quite often. They are a nice small data type where I can fit 8 of them into...
September 13, 2012 at 7:56 am
First let me apologize for the poor wording (True/False instead of Yes/No) and say in my defense that I understand that my skill with the English language is exceeded only...
September 13, 2012 at 7:37 am
JamesMorrison (9/12/2012)
lianvh (9/11/2012)
I am frustrated, because , a consultancy firm used this tool and now to keep the peace we have to implement this setting.
There is nothing wrong with doing...
September 12, 2012 at 1:29 pm
Not to my knowledge, however if you right click on the tab heading you can split it off into a new vertical/horizontal tab group. Also if you save the...
September 12, 2012 at 1:14 pm
waeva (9/12/2012)
Kenneth.Fisher (9/12/2012)
1) I'm not seeing GroupID but you can see the list of columns available for traces
It shows up if you select 'Show All Columns' in Events Selection...
September 12, 2012 at 12:34 pm
waeva (9/12/2012)
1. Ran a trace and got a Login Failed. These were the interesting columns :
GroupId - BLANK (was 1 when it succeeded when i manually put default db)
LoginSid -...
September 12, 2012 at 10:11 am
Thanks! Now do you know any way to tie the query to the database where it was run?
September 11, 2012 at 7:52 pm
Viewing 15 posts - 136 through 150 (of 617 total)