Identity Reseeding
I love the identity property. I use it in many of my tables, mostly because it gives me a fairly...
2011-05-31
2,426 reads
I love the identity property. I use it in many of my tables, mostly because it gives me a fairly...
2011-05-31
2,426 reads
On June 1st GITCA will run a 24 hour round-the-world virtual event focusing on Cloud Computing. Please visit http://sp.GITCA.org/sites/24Hours for...
2011-05-31
1,576 reads
It’s that time of year again, actually a little earlier than in previous years as we’ll be holding our fifth...
2011-05-31
1,491 reads
Let’s face it, a lot of us don’t enjoy attending meetings and can often find them to be a bit...
2011-05-31
1,805 reads
Here’s another awesome SQL event coming to New York City. (Keep reading for your discount below!) It’s already getting hot...
2011-05-31
2,353 reads
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the...
2011-05-31
25,940 reads
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
1,556 reads
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A...
2011-05-31
1,364 reads
Security is an important consideration when designing a database application. Who can get access to what data? How much damage...
2011-05-31
2,095 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