How Many Bytes Are In My Column? – T-SQL Functions
One of the things you want to be aware of when writing T-SQL is using the proper function for a...
2011-03-25
4,024 reads
One of the things you want to be aware of when writing T-SQL is using the proper function for a...
2011-03-25
4,024 reads
What is NOLOCK?
NOLOCK is a table hint for SQL Server that tells the engine to not take locks and ignore...
2011-03-25
1,722 reads
First Things First
At UKOUGs’ Back to Basics Special Event held in London today (Mar 24th), Niall Litchfield presented a very worthwhile...
2011-03-25
617 reads
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
2011-03-25
1,689 reads
As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they...
2011-03-25
738 reads
If you have been following my trials with working with C# and files you know it hasn’t been a bed...
2011-03-24
1,118 reads
The long wait for the new, mobile Sandy Bridge processor equipped laptops is nearly over. Most of the large system...
2011-03-24
1,100 reads
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-24
2,373 reads
G’day,
Occasionally, I hear things that surprise me. And one of the statements that I’ve heard lately that fits into that category is...
2011-03-24
385 reads
Last week I spoke at the TechFuse event in Minnesota – out at Mystic Lake Casino. As I mentioned in the...
2011-03-24
468 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers