Sometimes memory issues are not down to available physical memory but virtual, you have a lot of memory and you are already using the -g switch, i would be tempted...

I am not entirely sure if you can do transformations but you can write custom procedures to handle the pre and post changes to the subscriber

remembering from memory, in sql...

nazaninahmady_sh (10/28/2009)

---

ooooooooo no

i want to have store procedure that do this:

ALTER PROCEDURE [dbo].[DownloadCount_SP]

@FileCodesql int

AS BEGIN

update [File]

set DownloadCount=DownloadCount+1

Where FileCode = @FileCodesql

END

and this store proceduure...

I am not the first and probably wont be the last to say this.

Memorising so-called interview questions is not a good idea, could you actually explain how you came to...

There is a lot of information on triggers in Books Online, it is too big a subject to discuss it individually to a detailed level.

Does the value still need to be a datetime, if not then the following should help

select CONVERT(varchar(16), getdate(),120)

I thought you didnt want seconds or miliseconds :ermm:

Lian Pretorius (10/28/2009)

---

Thanks a mil Adi,

This isn't 100% what I was looking for, but is definately a step in the right direction, I'll play around with the counters & see...

I...

Steve Jones - Editor (10/27/2009)

---

I think what we're looking for is what would you like? I'm not sure PASS has benefits for you now, but if they could offer something,...

Steve Jones - Editor (10/26/2009)

---

Jack,

Good points and I do think we need to remember it's the Summit. In the past, PASS (the organization) has not offered much more than the...

sahoong (10/27/2009)

---

The Gurus,

I ran a restore database statement and it completed without any error but ever since the database is not accessible and it just display a message that the...

I differ in my opinion to the precious post, BI is more widely used, than a straight DBA role, on a ratio of roughly 10:1 in favour of BI in...

Steve Jones - Editor (10/26/2009)

---

Note that I'm not recommending Hyper-V. I'm not sure it's any better, or any worse, than other software. I have seen VMware used heavily, and it...

You would make a good primary school teacher :-D, nice reply btw