Viewing 15 posts - 5,221 through 5,235 (of 19,560 total)
george sibbald (1/12/2013)
easily done, I only noticed because the post just duplicated an earlier one.And its later in the day here.............:-)
Yeah that's it - I'll cling to that excuse 😉
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
January 12, 2013 at 9:06 am
SQLSACT (1/12/2013)
The application that uses this SQL Server is installed on the server as well and is very resource intensive
My first step would be to split these two servers.
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
January 12, 2013 at 9:04 am
I didn't even look at the date diffs between the latest comment and the rest of the thread. Just watching the active threads and responded - d'oh
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
January 12, 2013 at 8:57 am
it depends on the type of recordset. It is possible through several different means.
One of the easier methods is to add a sql script in the loop and pass...
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
January 12, 2013 at 8:41 am
I think more information is necessary on this. Looping through 9 million records 1 at a time is rather slow and inefficient.
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
January 12, 2013 at 8:31 am
Good to hear
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
January 12, 2013 at 8:25 am
na1774 (2/16/2012)
What would DBCC CHECKDB do? Why do I run it?Can u please explain me?
With the errors that you got, your database may now have consistency errors. 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
January 12, 2013 at 8:24 am
Not sure which you are asking for on this so here are examples of
1. Use data from SQL Server to populate a combobox
http://stackoverflow.com/questions/13542057/populate-combobox-vb-from-sql-server-database-table
2. Insert data into SQL Server using a...
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
January 12, 2013 at 8:22 am
suvo.kundu (1/12/2013)
Id Record1 Record2 ...
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
January 12, 2013 at 8:17 am
I haven't tried it but it makes sense that it would work so long as the compatibility mode does not change for the RS databases.
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
January 12, 2013 at 8:13 am
Nasreenm (1/12/2013)
Thanks. I think Microsoft should provide an official training kit if it doesn't want people using brain dumps...
Gail said it well. I want to add that with...
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
January 12, 2013 at 8:10 am
Better a witty fool than a foolish wit.
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
January 11, 2013 at 12:47 pm
These are all questions best discussed with your Microsoft Rep.
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
January 11, 2013 at 11:04 am
Daniel Bowlin (1/11/2013)
SQLRNNR (1/11/2013)
crookj (1/11/2013)
SQLRNNR (1/11/2013)
anthony.green (1/11/2013)
Stuart Davies (1/11/2013)
anthony.green (1/11/2013)
SQLRNNR (1/10/2013)
amnestyinternational
Rescue
So many to choose from.
Brains (just because I was reading this, this morning http://www.dailymail.co.uk/news/article-2257951/Kentucky-Fried-Brain-Students-horror-finds-wrinkled-organ-inside-chicken-KFC-experts-insist-just-kidney.html)
twisted
Sister
Shakespear's
Young bones groan
Out Out Damn Dog
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
January 11, 2013 at 11:01 am
It depends on how it is being used in the query. Also, is it possible that it is a multistatement instead of an iTVF?
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
January 11, 2013 at 10:31 am
Viewing 15 posts - 5,221 through 5,235 (of 19,560 total)