Viewing 15 posts - 18,571 through 18,585 (of 19,560 total)
In addition to what Braindonor has said, please post table structure and actual execution plan with your specific questions. Doing this enables forum members to best help you.
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 21, 2009 at 4:06 pm
smithsp17 (12/21/2009)
I'm trying to set up transactional replication between 2 transactional database instances, both SS2005, but am new to this. If I understand correctly, I set up a distributor...
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 21, 2009 at 4:04 pm
Hey Iron Chef, did you remove the query? I see no query in any of your posts. Just curious.
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 21, 2009 at 4:00 pm
Why not just use char datatype? Are you just pulling the value from the database and then using the app to render the color based on the value in...
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 21, 2009 at 3:56 pm
For assistance with this, we need to have the table structure, index structure and actual execution plan.
Please post this information to help us help you.
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 21, 2009 at 3:52 pm
IMHO, SSIS will be slower for this kind of process.
As homebrew said, you could use the GUI to script the changes. And then run them from the server itself.
Also,...
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 21, 2009 at 3:45 pm
To restore the other system dbs, no. You only need to restart in single user mode for the master db.
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 21, 2009 at 3:42 pm
http://msdn.microsoft.com/en-us/library/ms190679(SQL.90).aspx
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 21, 2009 at 3:42 pm
We actually run a cluster with An active node per Instance. Node A has one instance and Node B has a different instance. Performance degradation is minimal 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 21, 2009 at 3:34 pm
which is what exactly?
Anybody celebrate Boxing Day?
I think it is MMA Day here in the states these days 😀
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 21, 2009 at 3:25 pm
http://msdn.microsoft.com/en-us/library/ms177429(SQL.90).aspx
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 21, 2009 at 3:21 pm
Raghavender (12/21/2009)
Can we defrag the clustered indexes ?
when I am running query:
select * from sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')
I am getting the same index two or more times on...
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 21, 2009 at 3:13 pm
I am not certain I follow your question.
The code does do a select top 26, and then an additional insert after that for 27. The insert for 27 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 21, 2009 at 3:06 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 21, 2009 at 1:15 pm
Carlos Pereyra (12/21/2009)
Any reason why you're not using alter table alter column?as in alter table mytable alter column my column bigint?
Carlos.
The best answer is - as a safeguard - but...
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 21, 2009 at 1:15 pm
Viewing 15 posts - 18,571 through 18,585 (of 19,560 total)