An incomplete answer that generates a syntax error cannot possibly be a correct answer, therefore only option 4 is correct. 😀

--Method 2:

--use the internal structure of datetime(2)

cast(cast(reverse(substring(cast(@t as binary(9)),2,5))

...

I recommend you read Paul Randal's blog about backup myths: http://sqlskills.com/blogs/paul/post/A-SQL-Server-DBA-myth-a-day-(3030)-backup-myths.aspx

30-05) a full or differential backup clears the log

No. A log backup includes all the log since...

Thanks for this

Do you know of a way to check if my an instance is experiecing a plan cache bloat? What I mean is, how can I check what the...

Check out the following: http://www.sqlservercentral.com/Forums/Topic1340744-391-1.aspx

If you order by Virtual_memory_committed_kb, you should see MEMORYCLERK_SQLBUFFERPOOL as the largest consumer of memory.

select * FROM sys.dm_os_memory_clerks

order by Virtual_memory_committed_kb desc

I'm still trying to...

SQLSACT (11/7/2012)

---

kylesway (11/7/2012)

---

CACHESTORE_SQLCP

These are cached SQL statements or batches that aren't in stored procedures, functions and triggers. This includes any dynamic SQL or raw SELECT statements sent to...

rocky_498 (11/7/2012)

---

I need help to write a sql query, Here is my Query

to find out Fragmentation Level is more than 30% in the database

DECLARE @DBId INT

SET ...

Hit the wrong button... 😀

To undo the operation, I right clicked on the Replication Folder and selected Disable Publishing and Distribution. I then seleced the Yes, Disable Publishing on this...

First and foremost, my advice would be...

Dup

It depends on what you mean by "problem" and what the stored procedure is doing. While it's...

Sqlism (11/6/2012)

---

Thanks for the reply

i dont see anything mentioned in the link that we can change port 1433 as port number for default instance,

i am sure we can change it...

Animal Magic (11/6/2012)

---

Check out Adam Machanic's WhoIsActive procedure. Its fantastic for this sort of thing and comes with excellent documentation on multiple uses of it

http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx

Hope there isn't any issues...

We referred to that as an ID 10 T error...

If you are truly trying to find the cause of the blocking that is occurring on your system, then...

Your best sources for material to study for the exam are SQL Server Books on Line, the MSDN site, this SQLServerCentral.com site, and...