Viewing 15 posts - 5,221 through 5,235 (of 19,564 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 😉
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.
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
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...
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.
January 12, 2013 at 8:31 am
Good to hear
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...
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...
January 12, 2013 at 8:22 am
suvo.kundu (1/12/2013)
Id Record1 Record2 ...
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.
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...
January 12, 2013 at 8:10 am
These are all questions best discussed with your Microsoft Rep.
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
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?
January 11, 2013 at 10:31 am
Viewing 15 posts - 5,221 through 5,235 (of 19,564 total)