Viewing 15 posts - 18,676 through 18,690 (of 19,560 total)
In SQL 2005, this can be accomplished through the use of a recursive CTE.
It sounds like you are building a Binary Tree, is that so?
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 17, 2009 at 10:34 pm
I would go to the client and propose two options - fix it (not a band-aid) or leave it as is. We had a funky setup similar to that...
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 17, 2009 at 10:28 pm
Please also the provide stored procedure and table structures.
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 17, 2009 at 10:21 pm
This sounds reasonable (have done a very similar thing).
For the executing query text, this should get you headed in the right direction.
select
session_id
,start_time,command, st.text
,last_wait_type
from sys.dm_exec_requests r
cross apply sys.dm_exec_sql_text(sql_handle) AS st
go
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 17, 2009 at 10:18 pm
Try this:
Add the IP and the FQDN of the witness to your DNS server. Add the fully qualified domain name of the principal and the witness in the host file...
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 17, 2009 at 10:02 pm
And after you reconfigure for the 2GB, what happens when you update stats?
Also, is the bad plan consistent? Is it slow on repeated executions of the query?
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 17, 2009 at 6:22 pm
That outclasses my laptop. I only have 2GB on it and am running SQL 2008 (and Server 2003). Performance is fine for what I am doing - development...
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 17, 2009 at 6:08 pm
correct on the getdate()
Just set the fields to be default values of the functions listed.
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 17, 2009 at 6:05 pm
Then again, maybe not.
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 17, 2009 at 5:10 pm
Looks like it may be time for a new one already.
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 17, 2009 at 5:06 pm
Were you getting any error messages for the maintplan?
From Technet:
The Rebuild Index Task uses the ALTER INDEX statement when connected to SQL Server 2005, and the DBCC DBREINDEX statement when...
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 17, 2009 at 4:07 pm
SQLRookie 6502 (12/17/2009)
Files are supposed to populate in specific queues when certain criteria are met.
What is the problem you are running into (programmatic or logic)? What are the specific...
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 17, 2009 at 4:03 pm
Does anybody see a broken image in place of their avatars or images here at SSC?
About half of the Avatars show a broken image icon in lieu of my pic,...
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 17, 2009 at 3:40 pm
Matt Miller (#4) (12/17/2009)
GSquared (12/17/2009)
The Dixie Flatline (12/17/2009)
Is it just me, or is there a sudden frenzy of demands right at the end of the year?
Probably people trying to solve...
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 17, 2009 at 3:13 pm
Paul White (12/16/2009)
nmoore (12/16/2009)
Transportable filegroups would be nice.You'd need to downgrade to Oracle for that.
nice
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 17, 2009 at 12:55 pm
Viewing 15 posts - 18,676 through 18,690 (of 19,560 total)