Viewing 15 posts - 4,291 through 4,305 (of 8,416 total)
Bill Kline-270970 (4/2/2010)
April 3, 2010 at 7:46 am
sp_lena1225 (4/2/2010)
From what I read Target server memory is how much SQL Server is willing to have. Total is how it currently has.
Just the Buffer Pool, but yes.
If Total is...
April 3, 2010 at 7:43 am
Judy-363345 (3/31/2010)
Mytable has around 50000 rows and return result 48000 rows. There are non-clustered indexes on UID,ReferenceNumber, Type. it...
April 3, 2010 at 7:36 am
Just to check: "OBBEAVER" is a remote server, right? It's not a loopback - that is, a linked server that points to the originating server?
April 3, 2010 at 7:27 am
richellere (4/3/2010)
select cast(getdate() as date) doesn't work on SQL Server 2005
Bross mentioned that. 🙂
April 3, 2010 at 7:25 am
You can optimize the query by using local partitioned views. These use check constraints to eliminate unneeded partitions at compile time.
I must confess that I dislike...
April 3, 2010 at 7:24 am
jayanth-463157 (4/2/2010)
Can all tables (20 of them) share the same partitioning function and partition scheme?
The simple answer is yes, they can.
April 3, 2010 at 7:18 am
lmu92 (4/3/2010)
...it seems like the major issue is the alphanumeric key...
I may have misread the code, but it seems that the 'alphanumeric key' is simply the character 'C' followed by...
April 3, 2010 at 7:16 am
Are you using Query Analyzer or SQL Server Management Studio?
If it is SSMS, what messages do you get on the Messages output tab?
April 3, 2010 at 7:04 am
Mike Levan (4/3/2010)
No, I dont have NULL 's from the query result.
There are lots of possibilities here, so I'm going to take them one by one.
Does the following query return...
April 3, 2010 at 6:47 am
Bhuvnesh (4/3/2010)
Mike Levan (4/3/2010)
SET ANSI_WARNINGS ON@paul-2 : Still can we expect ANSI_WARNINGS OFF ?
Not if that statement was executed in the query window - but I didn't watch him run...
April 3, 2010 at 6:42 am
abcim (4/3/2010)
The two employees that are associated with the most recent comments added. You always want to see two different employees. Is that correct?
Exactly I want the two different Latest...
April 3, 2010 at 6:31 am
beejug1983 (4/3/2010)
I have a db, one of my colleague opened the .mdf file in scite editor & deleted few rows from that .mdf file.
Well that was a bit silly, wasn't...
April 3, 2010 at 6:28 am
Mike Levan (4/3/2010)
April 3, 2010 at 6:21 am
Viewing 15 posts - 4,291 through 4,305 (of 8,416 total)