Script Drop all tables of a database
Hi people, following a script that deletes all tables in a database. Enjoy.
SET NOCOUNT ON;
DECLARE @Tabela TABLE
( Seq INT,...
2010-12-27
2,101 reads
The MCM Journey
I’m not really planning on getting the MCM. Perhaps I’ll change my mind, but it’s not the time for me...
2010-12-27
848 reads
SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-27
9,514 reads
PBM and PowerShell
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-25
2,361 reads
Merry Christmas
This is just a short post for a Friday and not just any old Friday either, Santa is on his...
2010-12-24
563 reads
Server Side trace
Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using...
2010-12-24
510 reads
Get SQL Scripts Manager for Free
Red Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes...
2010-12-23
742 reads
PASS Summit 2010 Session Eval Results
Speakers and bloggers alike crave feedback (good or bad) so I was excited to see my session evaluations from the...
2010-12-23
1,049 reads
SQL Bits 8
It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th...
2010-12-23
508 reads
PASS Summit Speaker Evals – THE ANALYSIS
Rule: No Sushi with Adam within 24 hours of session
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS...
2010-12-23
788 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers