Viewing 15 posts - 11,356 through 11,370 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2013 at 8:32 am
dan-572483 (10/9/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2013 at 6:10 am
dan-572483 (10/9/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2013 at 9:02 am
A better solution might be to change the column to numeric. Or is that not possible?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2013 at 7:42 am
Other than the fact that you won't see any results, no.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2013 at 7:18 am
Viewing 15 posts - 11,356 through 11,370 (of 49,552 total)