Article of the Week – SQL Server 2008 T-SQL Enhancements
I have been following this series of articles since the first article was published on SQLServerCentral. The author, Arshad Ali,...
2009-09-02
735 reads
I have been following this series of articles since the first article was published on SQLServerCentral. The author, Arshad Ali,...
2009-09-02
735 reads
I had a great session for the 24 Hours of PASS on Building a Better Blog. Not sure how well...
2009-09-02
636 reads
Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...
2009-09-02
626 reads
I suspect I’m not alone in that I’ve had SQL 2000 running for a long time with no problems and...
2009-09-02
417 reads
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
2009-09-02
1,442 reads
Just a quick note to call out that I've had an article posted on SQLServerCentral that shows how to retrieve...
2009-09-02
440 reads
Prometric is offering 15% or 20%, or 25% off on selected Microsoft certification exams. The lower level Technology Specialist (TS)...
2009-09-02
598 reads
I completed a maintenance release of SQL Server PowerShell Extensions, which address all known open issues. This release is still...
2009-09-02
626 reads
Jack Corbett sweated over the schedule, not easy to decide what sessions to use and where to put them, but...
2009-09-02
324 reads
I’ve been thinking about the problem of connecting people at events for a while – what could we do to make...
2009-09-02
1,433 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...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers