Optimise SQL Server queries with these advanced tuning techniques
Now that you know how to speed up your SQL Server database queries, you can start delving into some of the more advanced tuning options.
Now that you know how to speed up your SQL Server database queries, you can start delving into some of the more advanced tuning options.
If you are near Texas Christian University, you might want to check out this training from a SQL Server MVP.
Test data is critical to being sure your application works, but is production data ok to use in test environments?
Being a part of the community means that there are certain standards that we'd like you to adhere to. Steve Jones brings you a few reminders of how to behave when posting in the community.
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
This is the third article that deals with analyzing the various possibilities involving various RAID setups and differing numbers of hard drives. We used the same hard disks again here: eight Samsung HM321KJ SATA/300 drives powered all of the possible RAID 0, RAID 5 and RAID 6 setups, with from three to as many as eight hard drives configured to use stripe sizes of 4 to 128 kB.
Ivan Pepelnjak describes a few ways to extract data from SQL databases and serve it to an AJAX application running in a web browser.
Who owns the data that we generate ourselves? It's not as easy to answer that as you think.
Its a graphical representation of login creation in SQL Server 2005 for SQL Server Authentication Mode.
How many of you have ever used SET CONTEXT_INFO in your SQL Server applications? Chances are it is not something you have been exposed to, but new author Yousef Ekhtiari brings us an example of how this particular construct can be used in your application.
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers