Nice question! Learned something new.:-)

Easy question. Thanks!

Thanks for the easy points to start the weekend 🙂

Thanks for the nice question. Had the gut feel about the correct answer but tested it again on my desktop. 😎

Too easy for QoD! 🙂 Thanks.

Okay, I think I got it now :-). These are special traces run by SQL Server to provide proactive caching & notifications to SSAS.

It is well explained on jason's blog...

After digging in it looks like it is not a server side trace or a profiler trace. When checked from sys.dm_exec_sessions the host process is SQL Server Analysis Services &...

Lowell (8/6/2012)

---

wierd;

i cannot get a trace to be created with either the options or the filename to be null;

it's wierd that you are able to see that.

i tried stuff like...

Thanks Kennedy:-).

Please put the script over there. I can see only a text box which is really cleaned up 😀

Nice, easy one 🙂 With total 6 options available as answer choosing 5 was easy by leaving the SQL Server 2008 Standard Edition.

Although I got the point 😎 because I assumed that you are talking about huge log backup file size (because that is something to note when you use bulk logged...

The third...

Little Nick (7/26/2012)

---

In my services, this is my SQL Server (MSSQLSERVER)

1.

2.

3.

4.

I've a question based on below image,

1. What's Log on as Local System account?

1. What's Log...

Please do not post duplicate threads.

http://www.sqlservercentral.com/Forums/Topic1335685-145-1.aspx?Update=1

amitsingh308 (7/26/2012)

---

Write function as

CREATE FUNCTION InitCap (

@string varchar(255)

)

RETURNS varchar(255) AS

BEGIN

RETURN upper(left(@string, 1)) + right(@string, len(@string) - 1)

END

and then write...