Viewing 15 posts - 2,281 through 2,295 (of 3,738 total)
prudhivi9 (9/9/2011)
can any body solve this issue....
Post removed.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 7:31 am
I could not find a work around but you can change it in SSMS.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 3:25 am
Visio has come a long way and it is relatively inexpensive.
I purchased ErWin a few times but I'm not aware that it has the functionality that you are looking for.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 2:16 am
After you purge the data you can shrink and rebuild the indexes, Be careful as to what size you shrink to or you will have fragmentation.
If you move data from...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 1:54 am
Basically:
sp_RENAME '[OldTableName]' , '[NewTableName]'
http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 1:34 am
Please specify the exact object names, old table name, new table name and the exact syntax that you are using.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 1:24 am
Ivan Mohapatra (9/9/2011)
will the transfered 6 gb data will be automatically compressed to around 3 to 4 gb after doing archive.
Do yo mean will it not be fragmented or compressed.
In...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 1:22 am
Ivan Mohapatra (9/8/2011)
well i have a db of 20gb i want to archive some data into a archive db.
So,kindly guide me how to create a archive db in sql server...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 1:08 am
Are you going to perform an archive and purge?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 12:48 am
The answer to your question is no.
Usually a Candidate Key is obvious.
I have queried individual columns to identify what columns or combination of column make a record unique. It is...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 12:38 am
Is there anything in common between the files that load and the files that fail?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 12:23 am
http://sqlknowledge.com/2010/12/how-to-monitor-sql-server-cpu-usage-and-get-auto-alerts/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 12:05 am
Depending upon what you are doing you could partition the table(s) are perform a Merge Split.
I did this a few times when this was not an option but I don't...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 8, 2011 at 11:54 pm
The following is not specifically for Interview questions but it may help.
http://www.sqlservercentral.com/articles/Administration/commonclusterproblems/470/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 8, 2011 at 10:56 pm
The following article has additional information on the BCP Utility:
http://www.simple-talk.com/sql/database-administration/working-with-the-bcp-command-line-utility/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 8, 2011 at 8:19 pm
Viewing 15 posts - 2,281 through 2,295 (of 3,738 total)