Viewing 15 posts - 391 through 405 (of 9,641 total)
cphite (6/23/2015)
June 23, 2015 at 8:18 am
I'd suggest investigating Event Notifications or using a DDL trigger. Event Notifications will probably have less impact on your server.
June 23, 2015 at 7:33 am
In addition to what Gail has said, I always recommend setting MAXDOP at the server level to something other than 0. I point people to this KB article, https://support.microsoft.com/en-us/kb/2806535,...
June 23, 2015 at 7:29 am
I wouldn't say it is a good thing. SQL Server is probably doing a clean shut down, but if the reboot is happening when users are trying to work...
June 23, 2015 at 7:15 am
amit_pjoshi 52509 (6/16/2015)
Thank you so much for your response, here are answers on your questions might be it would help:
1) Number of customer getting from query= 84610
2) Yes we...
June 16, 2015 at 9:02 am
winston Smith (6/12/2015)
The infrastructure guys were doing some work a week or two ago and accidentally disconnected all VM's from the SAN.
Aside from the unplanned, horrible nature...
June 12, 2015 at 2:48 pm
How many customers are being returned?
Are you connecting to the same SQL Server from BIDS and the Report Server?
Are you connecting as the same user or with the same permissions...
June 12, 2015 at 2:45 pm
You can't implement a Windows Cluster using Windows 7, you need a sever OS.
June 12, 2015 at 2:35 pm
The db_datareader role is for granting users select access to user objects that have a SELECT permission. If you want users to be able to execute stored procedures you...
June 12, 2015 at 12:23 pm
Good advice thus far. Also, I've yet to meet a recruiter who isn't happy to help a talented person. It is how they make their money, and the...
June 9, 2015 at 12:58 pm
No one can answer that question for you. You have determine what you like to do. As a DBA you are most likely, especially as a junior dba,...
June 9, 2015 at 12:20 pm
You might get an advantage by having an index on both columns, but I think that you might be better of with a composite index on both Key values, especially...
June 9, 2015 at 12:17 pm
What are the settings for Max Degree of Parallelism and Cost Threshold for Parallelism?
Did you do an update statistics after migrating the database to the new server?
June 9, 2015 at 12:11 pm
ArnolddG (6/9/2015)
That works okay.
One more thing. My query is about 140 lines long.
Is there a way to do the If Then on one select column only...
June 9, 2015 at 12:09 pm
You cannot use named parameters with the OLE DB connection. The parameters in the mapping page are by ordinal starting with 0, so you need to map:
Variable Name ...
June 9, 2015 at 12:07 pm
Viewing 15 posts - 391 through 405 (of 9,641 total)