Useful tips for everyday
How do you store a table name in variables? Must declare the table variable “@tablename”. Can trigger be called in stored procedure? You can’t call…
How do I find compilation errors in SQL Developer? 3 Answers. control-shift-L should open the log(s) for you. this will by default be the messages…
What permissions is required to truncate a table? Permissions. The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner,…
What is Fast Forward cursor in SQL Server? This SQL FAST_FORWARD Cursor is a combination of FORWARD_ONLY, and READ_ONLY. It means the FAST_FORWARD cursor will…
How do you count sockets? Note – To calculate the remainder using a calculator: Divide the core number by the number of processors per core.…
Why is it a bad practice to select all columns from a table while querying? Binding Problems. When you SELECT *, it’s possible to retrieve…
How to get sum of multiple columns in MySQL? SUM of Multiple columns of MySQL table We have seen how the sum functionis used to…
How do I delete messages from service broker queue? Sample SQL script to delete messages in Service Broker Queue manually declare @ch uniqueidentifier. while(1=1) begin.…
What is good IOPS on san? 50-100 IOPS per VM can be a good target for VMs which will be usable, not lagging. This will…
How to troubleshoot a change tracking cleanup issue? To summarize, we suggest the following steps when troubleshooting change tracking cleanup issues: 1 Ensure that auto…