Viewing 15 posts - 7,066 through 7,080 (of 7,631 total)
IceDread (4/24/2008)
Exactly where in your lawbook in usa does it state that you have to pay taxes?
I heard a rumor that it is actually not included in your law and...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 25, 2008 at 6:41 am
because it gets its values from a table and table values can be changed.
I am not sure at this point what you can do about it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 25, 2008 at 6:16 am
Andrew Shaw (4/23/2008)
Thanks.Tried that and got this:
Cannot create index because the key column 'IX_CSD_NomIPTBLB' is non-deterministic
Ah, well, that is a diferent problem. I think that you might be able...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 24, 2008 at 8:58 pm
I've been out on a job. Sorry for throwing this out there and running, but I hoped it could get you started...
Jeff Moden (4/24/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 24, 2008 at 8:50 pm
Like this:
(convert(char(4),dbo.fn_GetTLB()))
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 5:19 pm
Here's something to get you started:
Select S.session_id, S.host_name, S.program_Name, S.Login_name, R.request_id
, L.*
, r.start_time, r.status, r.Command, r.database_id, R.blocking_session_id, R.wait_type, R.wait_time
From sys.dm_tran_locks L
Join sys.dm_exec_sessions S on L.request_session_id = S.session_id
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 5:02 pm
GROUP BY .. WITH ROLLUP can usually get you there.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 4:05 pm
sunshine (4/23/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 4:01 pm
Why not just do this?:
Select
SUM(Cast(DATALENGTH(C1) as BigInt)) as [C1]
, SUM(Cast(DATALENGTH(C2) as BigInt)) as [C2]
, SUM(Cast(DATALENGTH(C3) as BigInt)) as [C3]
, SUM(Cast(DATALENGTH(C4) as BigInt)) as [C4]
, SUM(Cast(DATALENGTH(C5) as BigInt)) as...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 3:09 pm
In excel, copy your data, then in a new sheet, use Paste, Transpose to rotate your data.
From there, you should be able to get it into SQL Server and use...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 2:37 pm
Agree with Michael: using BCP from a trigger is a bad idea, and re-querying data from another process synched with your trigger code (and that is what you are doing...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 2:18 pm
OK, here is my entry. This should be pretty close to what you want. Note that if you do not have case-sensitive collation on your database, then you...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 11:37 am
average Hard page faults below 10/sec should not be a problem.
Suggest you do the following:
1) Get the CPU% and the (correct) Disk Idle% for all of your disks
2) use profiler...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 11:17 am
Oops, good point.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 10:03 am
Steve Jones - Editor (4/21/2008)
Named pipes is an older technology, super-seeded by TCP Sockets.
Not disputing anything else posted here, but Named Pipes are nowhere near as old as TCP/IP sockets...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 22, 2008 at 4:47 pm
Viewing 15 posts - 7,066 through 7,080 (of 7,631 total)