Viewing 15 posts - 11,356 through 11,370 (of 49,562 total)
OnlyOneRJ (10/9/2013)
we want to search a text in all tables of a database..
All the text of all the columns of all the tables? That's going to be slow as molasses...
October 9, 2013 at 9:01 am
I don't believe it's possible. Even if there was a policy for it, policies are implemented by triggers and they're AFTER triggers and you can't roll a backup back.
October 9, 2013 at 8:32 am
dan-572483 (10/9/2013)
October 9, 2013 at 6:18 am
Yes, it will. ROLLBACK will undo all data modifications right back to the outer BEGIN TRANACTION (as per documentation)
Nested transactions are a lie, they don't actually exist. The second, third,...
October 9, 2013 at 6:10 am
dan-572483 (10/9/2013)
October 9, 2013 at 5:55 am
Minnu (10/9/2013)
Hi Team,Heard that "Running SQL Profiler on Production environments will degrade performance of server and it adds additional load on the CPU"
The 'running profiler on production environments' doesn't refer...
October 9, 2013 at 5:41 am
LutzM (10/8/2013)
Will it be consistent/reproducable or may it vary under certain conditions (e.g. parallelism)?
The latter. Which is why those many-one updates have such a bad rap (deservedly). It's essentially another...
October 9, 2013 at 1:44 am
K Currie (10/8/2013)
What if the syntax error isn't in the table name but in a column name?
If it's a missing column, the query won't even parse and won't start executing...
October 9, 2013 at 1:39 am
LutzM (10/8/2013)
if we update a "left" table in a 1 ..n relationship, will sql server perform n updates or will it just do a single update?
Single.
October 8, 2013 at 4:36 pm
Then you'll have to recreate the job from scratch. Once done, may I suggest setting up backups? The fact that it's a dev server does not mean it's unimportant.
October 8, 2013 at 2:01 pm
Restore a backup of MSDB as a user database, extract the job (it'll be in the sysjobs and sysjobsteps tables), recreate it.
October 8, 2013 at 11:57 am
If you want further help to possibly make it even faster, please post full query, table definitions, index definitions and execution plan.
October 8, 2013 at 9:31 am
In that case may I suggest a simple after/instead of insert trigger to check for (and fix) invalid data?
October 8, 2013 at 9:02 am
A better solution might be to change the column to numeric. Or is that not possible?
October 8, 2013 at 7:42 am
Other than the fact that you won't see any results, no.
October 8, 2013 at 7:18 am
Viewing 15 posts - 11,356 through 11,370 (of 49,562 total)