Random Ordering of Results using NEWID
A discussion of how NEWID can be used to help randomize the results returned from a SQL query.
A scenario I...
2011-05-26
1,148 reads
Blog Posts
SQL Server, Storage and You Part 2!
I saw 500 faces an rocked them all!
To those who attended my webinar today THANK YOU! If you didn’t…. There...
2011-05-26
652 reads
SQL University Troubleshooting Week: Keeping an Open Mind
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem...
2011-05-26
761 reads
SQLRally 2011 Women in Technology Luncheon
On May 12, during the first-ever SQLRally , we held the first-ever SQLRally Women in Technology luncheon! I moderated, and our...
2011-05-26
1,023 reads
SSRS Error: Unable to connect to remote server error
One fine day when I tried to connect to one of my staging report server I got the
“Unable to connect...
2011-05-26
5,344 reads
Survival Mode & Dodging Burn Out
One of the benefits of experience is that you can see problems coming, that doesn’t mean you have enough experience...
2011-05-26
736 reads
ABL: Always Be Learning
If you have been in the IT field for any length of time, I’m sure you have heard the phrase...
2011-05-25
1,533 reads
devLINK Technical Conference to be Held in Chattanooga, TN, August 17-19
This year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011....
2011-05-25
642 reads
Efficiency of Subqueries and OR conditions in SQL
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...
2011-05-25
955 reads
Looking Back at SQLRally Orlando
It’s been almost two weeks since we wrapped up our first SQLRally, and in some ways it hasn’t quite sunk...
2011-05-25
651 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers