Viewing 15 posts - 5,371 through 5,385 (of 49,552 total)
No. An update trigger fires for any update. You can do checks in the trigger using either the UPDATE() function or checking the inserted and deleted tables and then decide...
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
July 9, 2015 at 9:42 am
No, it won't. EventData is only for DDL triggers.
I don't think there's an easy way to do what you're asking.
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
July 9, 2015 at 7:58 am
Create an update trigger, it'll fire on every update. In the SQL that you have inside the trigger, doing whatever you want the trigger to do, you would filter WHERE...
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
July 9, 2015 at 7:51 am
Yes, the missing index recomendations are broken and sometimes recommend indexes which exist, and besides you should never create from the missing index details without lots of testing.
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
July 9, 2015 at 7:49 am
SSMS doesn't. SSMS is just a client tool. It sends queries to SQL Server and displays results.
One component of the SQL Server engine is the query optimiser. It's job is...
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
July 9, 2015 at 7:21 am
Maybe. Depends on the queries using the index.
Should be some detail in http://www.sqlservercentral.com/articles/Indexing/68636/
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
July 9, 2015 at 6:42 am
SQL 2008 doesn't have the ability to encrypt only backups, that was added in SQL 2014. is_encrypted in sys.databases indicates whether Transparent Database Encryption is enabled for the database
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
July 9, 2015 at 4:55 am
Taking one log backup a day is a very poor 'strategy'. If you're going to do that, just put the DB into simple recovery and then you don't need the...
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
July 9, 2015 at 4:07 am
If you schedule it every 10 minutes, then it will run every 10 minutes (unless the job is still running at the point it would run again, in which case,...
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
July 9, 2015 at 1:24 am
a4apple (7/8/2015)
All I am doing is two update statements in this procedure ... should I still use OPTION RECOMPILE???
Very hard to say without seeing the proc and the plans. Basically...
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
July 9, 2015 at 1:16 am
Welsh Corgi (7/8/2015)
What do you consider best practices?
Designing a backup strategy that meets the company's RPO, RTO and maintenance windows.
It's all well and good for you to say 'I feel...
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
July 9, 2015 at 1:14 am
giri10488 (7/8/2015)
i already tried on google but i want how its work exactly.
That's not something that can be explained in a forum post. One could write an entire book on...
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
July 9, 2015 at 1:09 am
Alvin Ramard (7/8/2015)
I've had it. Enough is enough! When are people gonna stop hiring people that don't have a clue about they're hired...
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
July 8, 2015 at 2:00 pm
Sounds like the kind of project that several of my colleagues do. I know some are between projects at the moment, and we definitely have the skills. Drop me a...
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
July 8, 2015 at 1:57 pm
r.sundarmca10 (7/8/2015)
Please give me set off high-availability interview Q&A with some real time examples.
Sure.
"Describe to me the last high-availability implementation you did. What technology did you use and why? What...
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
July 8, 2015 at 12:16 pm
Viewing 15 posts - 5,371 through 5,385 (of 49,552 total)