Viewing 15 posts - 211 through 225 (of 392 total)
Got it wrong, but learned something - which is the key
Hugo,
The knowledge tested is good, but the way the question has been built suggests to me that the author tried...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 4, 2011 at 6:36 am
WayneS
On my system, the last select starts with 328417.
Sorry Wayne,
On my system I get:
SELECT TOP (5) * FROM #Test WHERE RowID > 5000; - 5001
SELECT TOP (5) * FROM...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 29, 2010 at 6:27 am
Did you use SS 2005 to create the publicatin and subscription? To go from 2K to 2K5, you must use the 2K5 SSMS to create everything.
Also, make sure that you...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 27, 2010 at 8:33 am
Please provide the schema, all indexes and the select that is hanging.
I have databases with tables much greater than this and do not have issues.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 24, 2010 at 2:44 pm
Heres a link that might help you:
http://furrukhbaig.wordpress.com/2007/08/22/parameter-sniffing/
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 21, 2010 at 6:37 am
Good question - but, I think the answers and explanation are lacking.
The order of the clustered index is based upon the columns which make up the clustered index. (Change the...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 21, 2010 at 6:23 am
Try here:
http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2005-replication.aspx
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 20, 2010 at 6:22 am
Good Monday morning question - math test and logic while clearing the cobwebs and trying to get my first cup of coffee;-)
Made me think, question and reread.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 20, 2010 at 6:11 am
Rahul The Dba
Welcome to the forum. Good question. Many will complain about simplicity or the number of times that this type of question has been asked, but it is...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 17, 2010 at 6:45 am
Craig,
Excellent article. Can't wait to see the next one.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 9, 2010 at 6:54 am
Redgate's SQL Backup does in fact encrypt with either 128 or 256 bit encryption, your choice, as well as multiple levels of compression for the database dump.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 7, 2010 at 12:25 pm
Jeff
Heh... <soap box mode on>
I went looking for your desk, thought that you were sitting next to me or at least close by:hehe:
I standardize on a minimum of 2 years...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 6, 2010 at 6:43 am
Understood - now you can convert the extracted file by modifying the script to change the end of record. This has been a issue since files were being creaed on...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 3, 2010 at 2:10 pm
Convert the file before SSIS uses it.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 3, 2010 at 1:35 pm
Craig, This is a common issue when dealing with files from Unix/OS2 systems. The end of record mark for those systems is a LF and not CR/LF as a windows/DOS...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 3, 2010 at 1:25 pm
Viewing 15 posts - 211 through 225 (of 392 total)