Viewing 15 posts - 46,726 through 46,740 (of 49,571 total)
You need some column that defines which status is first for each code.
You cannot depend on the order that the rows are returned as that will change.
May 5, 2008 at 8:19 am
Pleasure. I don't bother bookmarking all the white papers, just use this rather.
http://www.sqlskills.com/whitepapers.asp
I don't know offhand of the article on why 1 file/cpu. Perhaps on the PSS engineer's blog? http://blogs.msdn.com/psssql
Soem...
May 5, 2008 at 8:15 am
SQL King (5/5/2008)
May 5, 2008 at 8:07 am
SQL King (5/5/2008)
May 5, 2008 at 8:06 am
SQL King (5/5/2008)
May 5, 2008 at 8:03 am
IMHO = In my humble opinion.
No.MID has any value,I look at only CODE
So how do you define the 'first' row for a specific code?
Remember, SQL Server has no concept of...
May 5, 2008 at 7:51 am
You can't add more filegroups to TempDB. Just more files (tempDB1.ndf. tempdb2.ndf, ...)
May 5, 2008 at 7:36 am
By 'first', do you mean the one with the lowest MID? If so, this will work for you.
SELECT <Column List>
FROM Emp Inner join
(SELECT MIN(Mid) AS FirstMID, Code FROM...
May 5, 2008 at 7:34 am
Yup.
It's something for you to consider when deciding whether to switch to simple or enable log backups
May 5, 2008 at 7:15 am
If you're not going to do tran log backups and you don't care about recovering to a point in time, in the case of a failure, then there's no reason...
May 5, 2008 at 6:12 am
What's the formula for calculating RGB from R, G, B? It's possible that T-SQL can do the maths.
You could create a calculated column in the table, which means the RGB...
May 5, 2008 at 6:08 am
Yup. That will work great if the backup was created on the server where the query is being run.
May 5, 2008 at 6:07 am
Here's something:
Working with tempdb in SQL Server 2005
An excerpt...
tempdb supports only one data filegroup and one log filegroup. By default, the number of files is set to 1. Multiple files...
May 5, 2008 at 5:57 am
No. those will be up to the query optimiser/query processor depending on memory availability, number of rows, etc
May 5, 2008 at 3:29 am
Note it's a resultset, so it's going to be difficult to get into a variable, unless you do something like this.
insert into SomeTable
execute ('Restore .... ')
select @SomeVar = [Database] From...
May 5, 2008 at 3:13 am
Viewing 15 posts - 46,726 through 46,740 (of 49,571 total)