moramoga (5/5/2009)

---

Hello all,

In a query I need to multiply a int with a decimal(18,2)....but the result is always giving me 6 decimals.....like 1500.000000. How can I cast it or format...

Ok, thanks guys for the link, I started reading the document, and it looks really interesting. I'll have probably have to have...

Nicholas Cain (4/21/2009)

---

Just going by the comparisons that are shown there it appears as though the disk on the new machine is not as fast as on the old (or...

J-F Bergeron (4/21/2009)

---

Ahhh!! Looks a lot more accurate now!

Here are the results...

LAZYWRITER_SLEEP222200010000

SQLTRACE_BUFFER_FLUSH52000040000

LOGBUFFER5001248412546

SLEEP_BPOOL_FLUSH5357421780

WRITELOG2413903750

PAGEIOLATCH_SH41671780

PAGELATCH_UP129629615

PAGEIOLATCH_EX462150

PAGEIOLATCH_UP246310

Can you see clearer in those? How do I know what they do,...

Ahhh!! Looks a lot more accurate now!

Here are the results...

LAZYWRITER_SLEEP222200010000

SQLTRACE_BUFFER_FLUSH52000040000

LOGBUFFER5001248412546

SLEEP_BPOOL_FLUSH5357421780

WRITELOG2413903750

PAGEIOLATCH_SH41671780

PAGELATCH_UP129629615

PAGEIOLATCH_EX462150

PAGEIOLATCH_UP246310

Can you see clearer in those? How do I know what they do, is there...

The query DBCC DropCleanBuffers does not seem to be reseting those counters to 0, ... is that Normal?

I just run DBCC DropCleanBuffers; select * from ...Stats.. and it still has...

Nicholas Cain (4/21/2009)

---

Free up the buffer cache and the proc cache and buffer cache

DBCC FREEPROCCACHE;

DBCC DROPCLEANBUFFERS;

Run your query, then look at the wait stats (this is a very basic version,...

I've used the master database for the query to show how it's not the query that is the problem, but really something on the server itself. I can run...

I checked to see what was the bottleneck on this operation, and got the same time when trying to push from the dev environnement, and insert into the QA Server....

Thanks Dave, I'll look into the script component to do a Big select case in Vb.net, that should do it! Thanks again!

Willem Tilstra (4/16/2009)

---

I'm trying to ALTER a stored procedure. About half way down in the stored procedure's code, a reference is made to a database. At the time I was...

Florian Reischl (4/15/2009)

---

I'm not sure if I understood right...

If you try to use the SCOPE_IDENTITY() to get the id of your currently inserted record this is not correct. The SCOPE_IDENTITY()...

Lynn Pettis (4/15/2009)

---

J-F Bergeron (4/15/2009)

---

I have seen a script where someone set up a "Database level trigger" and caught the sql text that was being sent to the server.

He...

I have seen a script where someone set up a "Database level trigger" and caught the sql text that was being sent to the server.

He used it to prevent...

You can create a procedure that will take @Start and @End as parameters, and query your...