Viewing 15 posts - 286 through 300 (of 455 total)
GSquared (11/24/2010)
Ninja's_RGR'us (11/24/2010)
GSquared (11/24/2010)
Per-processor is how most multi-user installations are done. CALs are mostly useful to very small shops with a small number of people accessing the system.
Sorry to...
November 24, 2010 at 8:08 am
interesting way to go about deployment....
I have always just used sqlcmd.
sqlcmd -U priveldge_login -P "secretPassword" -h-1 -t 10 -S TheNewServer\Instance1 -i "C:\tempew_deployment.sql"
November 24, 2010 at 7:26 am
just remember to script out your logins, server roles, SQL Agent jobs and SSIS packages (if any).
November 24, 2010 at 7:07 am
select [Item No.], [Description],
(select [Description] from tempdb.dbo.Test1 where [Item No.] = 'ITEMNO1' and [Language] = 'IT'),
(select [Description] from tempdb.dbo.Test1 where [Item No.] = 'ITEMNO1' and [Language] = 'DE'),
(select [Description] from...
November 24, 2010 at 6:59 am
select [Item No.], REPLACE([Description],[Description],'descr.english1') [Description],
(select [Description] from tempdb.dbo.Test1 where [Item No.] = 1 and [Language] = 'IT') [Description]
from tempdb.dbo.Test1 where [Language] = 'EN'
November 24, 2010 at 6:32 am
So putting all this together we have:
select * from tempdb.sys.objects where object_id = OBJECT_ID('tempdb.dbo.#testvm')Hope I've not missed anything 🙂
seems perfect to me....
November 22, 2010 at 8:20 am
BobSaint (11/19/2010)
November 19, 2010 at 3:23 pm
BobSaint,
yes, I am hard at work learning what powershell and SSRS can do.... one day, when it is all finished I will write an article on how I created...
November 19, 2010 at 1:46 pm
crazy4sql ,
the server must be over the threshold for 10 consecutive loops.
if you want to test, use something to cause your CPU to run over the threshold for at least...
November 18, 2010 at 6:01 am
hi crazy4sql,
the connection between the vb script and the alert is the raiserror command. when the error hits the sql server error log, the sql server alert service sees it...
November 18, 2010 at 5:31 am
sfrancis 18850 (11/17/2010)
But CPU utilization is just one of very many counters to be tracking. Virtual memory, page table entries, page faults, disk volume latency, network - not to...
November 17, 2010 at 10:27 am
matt.austin (11/17/2010)
Does this work for Virtual Servers? If not any suggestions?
yes, it will work on VM's as well as Physical servers.
November 17, 2010 at 7:22 am
No Jason. I do not have an docs, but i have a lot of hands on experience.
pausing the mirror and resuming for a index rebuild was the way I solved...
November 17, 2010 at 6:28 am
hrc (11/17/2010)
if you checked those two values e.g. every 10 seconds and the @CPU_BUSY had increased 8 seconds I would assume that it was running on...
November 17, 2010 at 3:59 am
arr.nagaraj (11/17/2010)
What about @@CPU_BUSY and @@IO_BUSY
if you checked those two values e.g. every 10 seconds and the @CPU_BUSY had increased 8 seconds I would assume that it was running on...
November 17, 2010 at 3:52 am
Viewing 15 posts - 286 through 300 (of 455 total)