Viewing 15 posts - 631 through 645 (of 1,583 total)
There's a good post by Dave Smith below:
http://forums.databasejournal.com/showthread.php?3090.html
I think this will help with what you need
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 9:39 am
Is there any chance these jobs were created on a 64-bit server? If so, please check this link: http://www.sqlservercentral.com/Forums/Topic737169-148-1.aspx#bm1420339
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 9:32 am
If this is a critical process, consider using MASTER.sys.sp_testlinkedserver @ServerName to check the availability of the server before you run your process(es). You could make a function or procedure...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 7:36 am
How was the linked server ADSI configured?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 7:17 am
How many columns are in this "large" table?
SELECT * (2 or 3 columns) FROM TABLE will run quite well most of the time, whereas if you have dozens of columns...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 21, 2013 at 11:10 am
Do they have to have access to the data source int he report builder? Can't you force it to use one and remove their permissions to view it altogether?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 21, 2013 at 10:25 am
There is an option to "hide" the data source in the list view (I believe you drill down to it via properties when you view the "Show details"). As...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 20, 2013 at 3:16 pm
You can't govern the log file growth - this is a logged operation. How "wide" is the index? i.e. How many columns are in it and how many...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 20, 2013 at 2:39 pm
While anything is possible, No.
Is this a non-clustered index?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 20, 2013 at 2:26 pm
This is a duplicate post
http://www.sqlservercentral.com/Forums/Topic1485438-391-1.aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 19, 2013 at 11:30 am
Please ensure:
1. Install Office 2007 Data Connectivity Components (http://www.microsoft.com/download/en/confirmation.aspx?id=23734)
2. Change the extension of your excel file to the proper extension (Ex: .xlsx)
3. Enable "Ad Hoc Distributed Queries" on the server...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 19, 2013 at 11:28 am
High CPU isn't the catch-all for things running slowly. I side with Sean on this one - what makes you think it's SQL?
If you do suspect SQL, then consider...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 19, 2013 at 11:20 am
Is this going to be running via an Agent job or something?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 14, 2013 at 2:38 pm
Query looks ok, but I would try adding a WHERE ObjectCategory = 'Person' or whichever you need
I would also try setting the security context to your authentication just to be...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 14, 2013 at 1:28 pm
Can you please post your query?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 13, 2013 at 10:57 pm
Viewing 15 posts - 631 through 645 (of 1,583 total)