Viewing 15 posts - 31 through 45 (of 115 total)
Something like this :
SELECT tblSysProcess.cpu as processor, *
from master.dbo.sysprocesses tblSysProcess
order by tblSysProcess.cpu desc
Greetz
Query Shepherd
February 28, 2013 at 12:51 am
It's an Intel XEON CPU E5450 Quadcore 3 GHz. Good enough?
This is also my opinion. It's a combination of several things that bring me out of trouble :
- Reducing the...
Greetz
Query Shepherd
February 28, 2013 at 12:38 am
Got a lot of SOS_SCHEDULER_YIELDS-waits and a very high signal time. Could it also be possible, that we just need more CPUs?
Greetz
Query Shepherd
February 27, 2013 at 2:10 am
I haven't installed it, but I'll give it a try. Either it's a dev license you can evaluate with your key, or you get asked for it at the installation...
Greetz
Query Shepherd
February 26, 2013 at 11:30 pm
Damn.../ only with internet protocols...never mind...my web developers also mix up / and \ very often...so it seems to be an webdev illness :-D.
You can change the port with the...
Greetz
Query Shepherd
February 26, 2013 at 11:25 pm
It seems to be really hard to remove it from SS 2012. The only clean solution could be to remove it and reenable it having then the possibility to choose...
Greetz
Query Shepherd
February 26, 2013 at 3:15 am
Are you working with the standard port 1434? Got allow remote connections enabled :P?
Greetz
Query Shepherd
February 26, 2013 at 3:09 am
Seems to be a dev license, that can be evaluated. Why don't you slipstream your existing media, already having preset the legal key?
Greetz
Query Shepherd
February 26, 2013 at 3:08 am
AFAIK it's related to UCP.
Greetz
Query Shepherd
February 25, 2013 at 12:46 am
Is SQL Server Browser runnning on the database machine?
Greetz
Query Shepherd
February 25, 2013 at 12:41 am
Try to change all varchar/char to nvarchar/nchar. You could do this either trough a view, or trough data conversion in ssis.
Greetz
Query Shepherd
February 25, 2013 at 12:39 am
Okay...a pingback would be nice...I know these problems...most of my work is done at night :D!
Greetz
Query Shepherd
February 22, 2013 at 6:47 am
- Disconnect all users from the cube
- Open Analysis Manager
- Right-click on server name
- Open Properties and you will be able to see Data folder on General tab (typically c:\Program...
Greetz
Query Shepherd
February 22, 2013 at 6:18 am
It's an alert message send via net send triggered by a certain event...
Refer to sp_add_alert in BOL for more.
Greetz
Query Shepherd
February 20, 2013 at 6:00 am
Viewing 15 posts - 31 through 45 (of 115 total)