Viewing 15 posts - 4,291 through 4,305 (of 6,676 total)
Sorry, but that won't work either - you need the following:
SELECT 1 WHERE '111' NOT LIKE '%[0-9]%'
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2010 at 2:36 pm
Schadenfreude-Mei (1/7/2010)
However...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2010 at 1:41 pm
Pradyothana Shastry (1/7/2010)
In Bulk recovery model can we take log backups?
It's not a question of whether you can or can't - it is a question of whether you must or...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2010 at 1:31 pm
That is good to hear - thanks for the feedback.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 7:05 pm
Before you go off and start creating multiple files - read this:
http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 3:19 pm
Lynn Pettis (1/6/2010)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 2:18 pm
Instead of trying to roll your own - and ending up with all sorts of problems - why don't you just use IDENTITY instead?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 2:15 pm
I don't think your error has anything to do with whether or not your data has commas in it. The error is very clear - you are attempting to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 2:12 pm
Just finished a quick test - converting to a scalar UDF took the following on my system:
SQL Server Execution Times:
CPU time = 984 ms, elapsed time...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 2:01 pm
Lynn, would schema binding that function make any difference to the performance? Could it be modified to a scalar UDF and would that make it perform any differently?
Just questions...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 1:47 pm
donne4real (1/6/2010)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 1:43 pm
And don't forget the cumulative updates - I think CU4 is the latest. 😉
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 1:35 pm
If you have any non-cluster aware components installed, you have to run the service pack on each node where they are installed.
For instance, SSIS and SSRS will not be updated...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 1:33 pm
Brian Tabios (1/6/2010)
I would not change the timing of your log backups at all - keep running them every hour. Think about how you would recover your system to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 12:53 pm
And fragment all of those nicely defragmented indexes - so, basically a waste of time. To save some space in your data file, you can try using the SORT_IN_TEMPDB...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2010 at 12:14 pm
Viewing 15 posts - 4,291 through 4,305 (of 6,676 total)