Viewing 15 posts - 16 through 30 (of 124 total)
WOW! That is a lot of joins on the same table/view!
My experience has been, if you need to join on the same table but with multiple criteria, it might...
October 21, 2015 at 5:47 am
Thanks for all of the inputs so far.
FYI, since this is a somewhat ambiguous question...
• Almost all of the tables have INT/VARCHAR datatypes. Definitely no BLOB, Text, NText,...
July 23, 2015 at 1:10 pm
What's the best way to find the SQL statements you need to tune? Here are some of the things we do (and, as we get more knowledgeable, we grow and...
May 1, 2015 at 5:50 am
Besides RedGate's SQL Prompt, we use AutoHotKey to automate certain key sequences. It is not a SSMS add-in but rather a Windows app, but we use it exclusively for SQL...
January 23, 2015 at 5:53 am
I was investigating the same issue and discovered that you need to do the following, when the login does not have dbo or sa permissions:
GRANT VIEW DEFINITION ON [Name...
November 19, 2014 at 12:04 pm
Thanks for the reply. However, what I am looking for is running this:
EXEC dbo.usp_MyStoredProcedure -?
The result would just list the parameters in the stored procedure and acceptable input(s) for...
August 29, 2014 at 8:53 am
Peter Brinkhaus (7/24/2014)
http://msdn.microsoft.com/en-us/library/dd207007(v=sql.105).aspxIf you have BOL installed, just lookup '\' in the index.
Peter, thanks for the link. Honestly, this is one case I never would have thought about checking BOL...
July 24, 2014 at 5:56 am
We use CLRs (have for some times) with custom C# code. Previously, it ran on all of our customer-facing SQL servers (non-SSRS report servers), now only one server uses it...
February 21, 2014 at 7:14 am
You could write a script to BCP out the data?
Here is something I run to generate data from a table to convert it into a SELECT statement:
USE MyDatabase
Go
DECLARE...
August 28, 2013 at 6:14 am
I know this is an older post, but we just ran into a similar problem and "googling" the issue, this was only one of two responses that came up.
We...
April 3, 2013 at 1:09 pm
I totally agree about blindly accepting missing index recommendations! 🙂
We run a process weekly that checks the server uptime (3 days or greater is our criteria), then capture all of...
March 14, 2013 at 1:02 pm
Sorry for any confusion... I believe there are a few levels of "ownership" (http://www.sqlservercentral.com/articles/SQL+Jobs/68764/) per my understanding?
1) The account that is configured to run SQL Server Agent...
February 11, 2013 at 11:59 am
Not what you may want to hear, but have you may have to convert the process (temporarily) to use a different methodology, if it is that important?
- Are you...
February 11, 2013 at 8:29 am
Nope. No proxies.
The job is actually run with a custom higher level account with full permissions in every database. Yes, it has full SA permissions... again, please no discussions...
February 11, 2013 at 7:54 am
Sorry for taking so long to response back on this... I know I personally do not like it when a thread suddenly "quits" without any resolution, especially when I am...
February 11, 2013 at 7:32 am
Viewing 15 posts - 16 through 30 (of 124 total)