SQL tips and tricks If you are having trouble configuring Splunk DB Connect database inputs, or if you have written overly complex Splunk Processing Language (SPL) queries to use with your DB Connect inputs, consider instead refining your SQL queries. Use the dbxquery search command to write...
The query processing team - query optimization & execution - providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server. Mystery of memory fraction in Showplan XML If you examine Showplan XML, you...
This paper introduces the online SAS(R) Tool, the SQL QueryWindow. Using the Query Window you can build complex SQL queries and reports, with only a little knowledge of SQL and Proc Report. This is a useful tool for checking and debuggingprograms that use relational data. It provides a ...
Connect to your SQL Server instance. Expand Management > SQL Server Logs. Right-click the Current error log, and then select View SQL Server Log:Query the error log in SSMSConnect to your SQL Server instance. Open a New Query window. Paste the following Transact-SQL code in your query ...
So, to avoid multiple parsing of the same query and to s(h)ave some time (off), use the bind variable. TIP#5 – Avoid using OR in join conditions It’s hard to explain why, but some people have a habit of joining two tables one way OR another. This results in a decrease of ...
Sometimes we see the below error in SQL Server 2008 R2 SP1 when executing a query in SQL Server... Date: 07/15/2014 Can I decrypt TDE enabled database if I have access to the master database’s mdf and ldf files or the master database backup? If someone gets access to the master...
sql tricks: COALESCE how NULL works row-oriented vs column-oriented databases sql tips: 3 ways to count questions to ask about your data sql exercises idea: take a table and some queries and write down the results by hand sql query steps the steps in a left join use x IS NULL, not ...
Recently there was a question on one of the MS SQL forum, the query which user had posted was pretty simple but was behaving strangely. Here I’m demonstrating you all the scenario which user had posted. Create two tables and inserted few records in both the tables. ...
A colleague of mine skyped me about a query that was running slow. Well, slow means that it ran for 90 seconds, and then it timed out, that is. Here is the little repro of the challenge: I know, I'm too lazy NOT … Continue reading To OR or …? → 2 Comments Why is ...
Clear theeditorand copy the query fromhere(This query is responsible on monitoring if Azure MI storage is above 90%) then paste it in theeditorand click onNew alert rule, please have a look at the following snapshot: An alert will be created using the above query, please...