Viewing 15 posts - 136 through 150 (of 617 total)
asifkareem (9/17/2012)
i thing on that side the...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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 -...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
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?
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
September 11, 2012 at 7:52 pm
Viewing 15 posts - 136 through 150 (of 617 total)