Viewing 15 posts - 2,671 through 2,685 (of 19,560 total)
Just curious, have you tried talking to the dev teams?
Another quick option is to query the system catalog sys.sql_modules for any procs that have the table name in the definition?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2014 at 7:17 am
onion
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2014 at 2:50 pm
nice question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2014 at 12:21 pm
Jeff Moden (7/8/2014)
SQLRNNR (7/8/2014)
Jeff Moden (7/8/2014)
The first day was spent filling out paper work and peeing in a cup." 😉Was that also a failure?:w00t:
Heh... no. I studied real...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2014 at 12:05 pm
This script should help you find it.
/* This has not been Tested on a CS Collation */
DECLARE @Path VARCHAR(512)
,@StartTimeDATETIME
,@EndTimeDATETIME
/* These date ranges will need to be changed */
SET @StartTime =...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2014 at 11:59 am
Jeff Moden (7/8/2014)
The first day was spent filling out paper work and peeing in a cup." 😉
Was that also a failure?:w00t:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2014 at 7:40 am
I love the statement...
if we never confront anything that we fear, or don't understand, then we risk stagnation
Stagnation as a DBA or Data professional is a terrible thing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 12:42 pm
Sean Lange (7/7/2014)
SQLRNNR (7/7/2014)
Sean Lange (7/7/2014)
SQLRNNR (7/7/2014)
grudespicable
moi
stuffed crust
ahi
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 11:23 am
Sean Lange (7/7/2014)
SQLRNNR (7/7/2014)
grudespicable
moi
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 11:16 am
Thomas Abraham (7/7/2014)
Nice question Christian. Thanks for contributing.
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 11:13 am
Are you seeing performance issues?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 11:03 am
gru
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 11:03 am
D.M. Corbett (7/7/2014)
So that is why I can't figure out why...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 10:56 am
Luis Cazares (7/7/2014)
Is he serious?
Well he does seem to be "High." :-D:-D:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 10:48 am
The values you have set are the defaults for SSRS in 2005.
Those defaults are based on "available" memory which is not the same as free memory. If you have...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2014 at 10:45 am
Viewing 15 posts - 2,671 through 2,685 (of 19,560 total)