Viewing 15 posts - 24,316 through 24,330 (of 26,490 total)
Go to redgate.com. If memory serves, they have a free tool that will read a SQL Server 2000 transaction log file (if your database is using the full or...
September 3, 2008 at 12:55 pm
GilaMonster (9/3/2008)
September 3, 2008 at 12:41 pm
What this does (colOne = @num1 or @num1 = 0) does is create a conditional where clause statement. If the value of @num1 = 0, you get all rows...
September 3, 2008 at 12:33 pm
rbarryyoung (9/3/2008)
You want the DENSE_RANK() function:
Select Id, DENSE_RANK() OVER(order by Id) as [Seq_Num]
From MyTable
Geez, get side tracked by work for a couple of minutes and someone beats me to...
September 3, 2008 at 12:14 pm
It really has nothing to do with SQL itself, it is simple logic.
Let's look at the first part of the WHERE clause:
(colOne = @num1 or @num1 = 0)
This part is...
September 3, 2008 at 12:07 pm
Also, is it possible that data may be deleted that may result in sequence numbers changing? Such as id 221777 in your sample data being deleted. Would 221778...
September 3, 2008 at 11:57 am
Okay, but that isn't an advantage. As for using it as a key, by itself, it isn't because it will duplicate with the id it is assigned. What...
September 3, 2008 at 11:53 am
Curious, what is the advantage of not having any gaps in the sequence numbers?
😎
September 3, 2008 at 11:44 am
My oldest two daughters (a senior and a freshman) go to a high school where every student is issued a laptop. They have a product installed that will locate...
September 3, 2008 at 10:24 am
The server-side trace will catch all events that it is set to monitor. It is also designed to limit the impact of tracing a SQL Server which is why...
September 3, 2008 at 10:02 am
Here is an example. I backed up the AdventureWorks database to AdventureWorks.bak, and the following code is restoring the database as AdventureWorksDB1:
RESTORE DATABASE [AdventureWorksDB1]
FROM DISK = N'C:\Program Files\Microsoft...
September 3, 2008 at 9:46 am
chris webster (9/3/2008)
... Think i'm going to retrain as a plasterer
Sounds too much much like physical labor, I'll stick with working with computers. It's just like like working with...
September 3, 2008 at 8:25 am
I wish I had a server configured where I could test it out. I'm just going on what I have read about databases and physical design. I think...
September 2, 2008 at 12:40 pm
I'd also take a close look at each recommendation. You may actually find overlapping indexes that could be merged into a single index.
I also agree heavily with testing all...
September 2, 2008 at 12:00 pm
I'd say if you can put the nonclustered indexes on a seperate filegroup on a seperate set of disks, you should. You can take advantage of parallel IO's between...
September 2, 2008 at 11:57 am
Viewing 15 posts - 24,316 through 24,330 (of 26,490 total)