Grant Fritchey (8/9/2011)

---

Anytime we're in Bradford, I have a pub selected. The only...

I spotted this drinking establishment during a fleeting visit to Bradford, UK, and thought of this thread...

I suspect it's the rendering of the email that gets rid of the char(13)s - assumes it's whitespace and gets rid of it.

Take a look at this blog post as a starting point:

http://strictlysql.blogspot.com/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html

From the query there you could filter out records where the objects (internal/user) allocated are significantly larger than...

Also

select * from sys.configurations

might have what you need

Powershell would be one way to do it:

http://www.youdidwhatwithtsql.com/auditing-your-sql-server-with-powershell/133

you could query sys.master_files and look for physical_name matching the .mdf you have.

GilaMonster (6/1/2011)

---

I always wonder about the threads where someone asks for a bunch of information and the OP replies to one question, then the person asks for the rest of...

Ivan Mohapatra (5/26/2011)

---

let me make it clear

1- is my windows server where all the website and database is been hosted and is live .

2 -is my laptop.

ok

1-

if i am taking...

What I generally do for things like this:

You can generate one script, then get it to be in a single line of code.

Then use Excel/some spreadsheet to do the work...

From what I've read, I don't believe there are any issues with running more than one t-log, but there are certainly no benefits (edit: performance-wise). The log is accessed sequentially...

I don't know whether this would be equivalent to your query, but if I run the slightly altered code below I get blocks of heads (or tails) with the same...

You wouldn't want to leave a transaction open for any length of time as that would cause blocking.

I guess you'd have to save the various values that are set in...

Hi

Have a look at PIVOT:

http://www.techrepublic.com/article/write-pivot-queries-in-sql-server-2005/6143761

Oh - I see where the confusion comes from.

When I said "a separate job to run every Tuesday" I meant separate from the job that needs to run, not a...