Viewing 15 posts - 856 through 870 (of 9,641 total)
Even though this site is owned by RedGate you might want to post this in the RedGate support forums. There isn't anything I can find in the UI that...
July 18, 2014 at 1:01 pm
You need to filter sys.dm_db_index_usage_stats by database_id like this:
SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],
I.[NAME] AS [INDEX NAME],
USER_SEEKS,
USER_SCANS,
USER_LOOKUPS,
USER_UPDATES
FROM SYS.DM_DB_INDEX_USAGE_STATS AS S
INNER JOIN SYS.INDEXES AS I...
July 18, 2014 at 12:56 pm
That expression get's yesterday's date not today's date. I usually just use =Today() as the expression to get today.
What error are getting?
July 18, 2014 at 12:51 pm
What do you mean by what started the job? Do you mean you want to know if someone is using a PoSH script or .NET application to start the...
July 18, 2014 at 12:41 pm
You can add a rowversion column to the table and do a comparison of the rowversion in the table and the rowversion stored in your app and then tell the...
July 18, 2014 at 12:35 pm
You haven't told us what you are using for querying the database? Are you using SSRS, .NET, java? What are you using for database access, ad hoc SQL,...
July 18, 2014 at 12:30 pm
wmoore 54341 (7/17/2014)
Does running rebuild/reorganize on an index cause any execution plans that were reliant upon that index to recompile the next time the stored procedure is run?
Rebuild definitely does...
July 17, 2014 at 2:00 pm
Yeah, it's a bummer. It would be nice if it was an errors collection like .NET has or a virtual errors table like inserted/deleted.
July 17, 2014 at 11:22 am
Definitely sounds like a parameter sniffing issue. The reason the ALTER works is because that causes a recompile at the next execution of the procedure. Updating statistics or...
July 17, 2014 at 11:17 am
You can't login using that login. Certificate based logins are designed to be used when signing a module (Procedure/function) that does a task that requires elevated permissions that you...
July 17, 2014 at 11:02 am
Greg Edwards-268690 (7/17/2014)
The Dixie Flatline (7/16/2014)
Cafe du Monde in the French Quarter? Probably a few miles as the crow flies. I'd take a cab.
First thing...
July 17, 2014 at 10:26 am
Sean Lange (7/17/2014)
Sadly I will not. I need to find a way to get to one though. It is a large chunk of change for me to have to fork...
July 17, 2014 at 8:58 am
Okay. I don't really get logging the new value since the new value is always the value currently in the table. All you need to do is change...
July 17, 2014 at 8:52 am
My first thought was that the report was using a cached version of the report, but that wouldn't be the behavior you are describing and it wouldn't explain why a...
July 17, 2014 at 8:27 am
The only way to show all the errors is to use THROW and let the client get the error. There is a CONNECT item about it found here.
July 17, 2014 at 8:22 am
Viewing 15 posts - 856 through 870 (of 9,641 total)