Viewing 15 posts - 751 through 765 (of 2,008 total)
Use replace function to replace single quote (') with two single quotes ('')
REPLACE ( string_expression , string_pattern , string_replacement )
December 20, 2011 at 4:42 am
At the end of the day, if business is asking for granular data or for an aggregation nobody thought before there is little choice but hitting the core tables.
On...
December 20, 2011 at 4:02 am
SKYBVI (12/19/2011)
Just wondering, when they will reboot the server,all the sql services will automatically be stopped and restarted...
Why you need to manually stop the services first then .?
Regards,
Skybvi
Stopped or...
December 20, 2011 at 3:49 am
@mkjohn: Please don’t hijack the thread. Start a new thread for your question (with details).
December 20, 2011 at 3:42 am
PaulB-TheOneAndOnly (12/19/2011)
pereubu (12/19/2011)
December 20, 2011 at 3:37 am
One snippet here, from BOL for your case (Replication & Transaction Log issue).
Merge replication and snapshot replication do not affect transaction log size, but transactional replication can. If a database...
December 20, 2011 at 3:19 am
Not Necessarily.
Please go through following articles. It will answer your current (as well as next) questions.
Troubleshooting a Full Transaction Log
http://msdn.microsoft.com/en-us/library/ms175495.aspx
Recover from a full transaction log in a SQL Server database
December 20, 2011 at 3:15 am
The index is fragmenting after data load. You need to add index rebuild / index defragmentation in your database maintenance tasks (or after BULK load).
For More: http://msdn.microsoft.com/en-us/library/ms177571.aspx
December 20, 2011 at 3:11 am
You cannot remove a file from the database unless the file has no existing data or transaction log information; the file must be completely empty before it can be removed.
For...
December 20, 2011 at 3:04 am
Hints
http://msdn.microsoft.com/en-us/library/aa196160(v=SQL.80).aspx
ROWLOCK
Specifies that row locks are taken when page or table locks are ordinarily taken. When specified in transactions operating at the SNAPSHOT isolation level, row locks are not taken...
December 20, 2011 at 2:39 am
Search for snapshot isolation level.
Isolation Levels in the Database Engine
December 20, 2011 at 2:13 am
Cath Trimble (12/20/2011)
The Dixie Flatline said county boundaries, not country boundaries.
Thanks for reminding me to visit Ophthalmologist :doze:
December 20, 2011 at 2:09 am
Henrico Bekker (12/20/2011)
GilaMonster (12/20/2011)
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
ALTER DATABASE Testing SET...
December 20, 2011 at 2:02 am
baabhu (12/20/2011)
One quick question. What approach will you take when it happens to your DB. Do you stop the DBCC checkdb and follow a different approach.
My db...
December 20, 2011 at 1:55 am
Koen Verbeeck (12/20/2011)
forsqlserver (12/20/2011)
Thanx Koen,But I just want to be precise and solid confirmation.
Actually, then you should check MSDN (or the F1 page), or call Microsoft support.
I can tell whatever...
December 20, 2011 at 1:47 am
Viewing 15 posts - 751 through 765 (of 2,008 total)