Viewing 15 posts - 18,646 through 18,660 (of 19,560 total)
So, you have no method or test cases or values for which you could use to test these procs?
Having valid test data to go with these procs would also help...
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
December 18, 2009 at 12:59 pm
You're welcome.
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
December 18, 2009 at 12:57 pm
Touching on something that Gus mentioned.
When the procs are moved into the database, there is better control on performance of the proc by the DBA. When the code is...
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
December 18, 2009 at 12:52 pm
atwite (12/18/2009)
How would you change the query to find duplicates if the entries were numbers? I have been tasked with creating a query that will...
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
December 18, 2009 at 12:36 pm
Lowell (12/18/2009)
SELECT
CASE
WHEN object_name(tr.parent_id) IS NULL Then 'Database'
...
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
December 18, 2009 at 12:30 pm
If the new file is in a separate filegroup, you move the data by moving the clustered index to the new filegroup.
Otherwise, it is as Homebrew said for if it...
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
December 18, 2009 at 12:26 pm
Is the child stored procedure able to execute independently of the parent proc?
Has the process ever worked?
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
December 18, 2009 at 12:24 pm
This script is a nice starter script. What I see from the script is that it lists all of the foreign keys. After that, you are required to...
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
December 18, 2009 at 12:03 pm
More information would be needed to best answer the question. As it is, we are only guessing at how best to help/answer your 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
December 18, 2009 at 11:59 am
Pricing is where I am coming from. In pricing the two, I have noticed the price gap close to about $100. For that $100 I can get 4GB...
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
December 18, 2009 at 11:57 am
Greg Edwards-268690 (12/18/2009)
x64 bit SQL 2008 R2
Box has the new 48 core Intel chip, single socket
Living on the edge....
Did Alvin change his avatar, or is Steve still...
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
December 18, 2009 at 10:55 am
In sys.objects the type is 'TR'
You would be able to pull a list of triggers that way.
Or you could query sys.triggers and get a list of the triggers and be...
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
December 18, 2009 at 10:35 am
I've been tempted to get a netbook but can't justify a netbook over a laptop when the prices I have seen are nearly the same.
Can you help me with the...
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
December 18, 2009 at 10:27 am
The user owns the schemas. You will need to transfer that or remove that user from owning the schemas.
http://msdn.microsoft.com/en-us/library/ms173423.aspx
You may want to verify that the account is not the...
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
December 18, 2009 at 10:24 am
what do you have in sysmessages for that error message?
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
December 18, 2009 at 10:20 am
Viewing 15 posts - 18,646 through 18,660 (of 19,560 total)