Viewing 15 posts - 961 through 975 (of 3,011 total)
JP Dakota (2/23/2011)
I was once asked for the absolute value of Pi. There isn't one....
I have to disagree; the absolute value of Pi is Pi.
Absolute value,
From Wikipedia, the free...
February 24, 2011 at 8:39 am
skcadavre (2/23/2011)
"What do your parents do for a living?"I just remember thinking - what in god's name has that got to do with anything?
It's good to have an answer that...
February 23, 2011 at 7:06 am
Your copy speed is way too slow even for a slow network connection. I just copied a 100 GB file over a WAN link using ROBOCOPY and it finished...
February 22, 2011 at 11:48 am
george sibbald (2/21/2011)
I don't think uptime is installed by default, you have to download it, so your servers might not have it.This any good via xp_cmdshell?
The UPTIME.EXE only has to...
February 21, 2011 at 5:29 pm
Have you tried using the windows UPTIME command?
Gives detailed command help:
uptime /help
Gives system uptime:
uptime \\MyServerName
\\MyServerName has been up for: 26 day(s), 9 hour(s), 17 minute(s), 56 second(s)
Gives history of system...
February 21, 2011 at 12:26 pm
Have you seen this? Seems to apply to large data types, like TEXT.
From SQL Server 2008 Books Online:
"Because of their size, large-value data types are sometimes stored separately from...
February 16, 2011 at 1:19 pm
oskargunn (2/16/2011)
CREATE TABLE [dbo].[Table](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[MachineName] [varchar](50) NULL,
[Service] [varchar](100) NULL,
[WebMethod] [varchar](100) NULL,
[Session] [varchar](50) NULL,
[Name] [varchar](50) NOT NULL,
127.0.0.1 [varchar](50) NOT NULL,
[Time] [datetime] NOT NULL,
[Duration] [float]...
February 16, 2011 at 9:27 am
The clustered index includes all the data pages, so are you certain that it wasn't already compressed?
February 16, 2011 at 7:40 am
TheSQLGuru (2/15/2011)
Michael Valentine Jones (2/14/2011)
February 15, 2011 at 10:03 pm
To restore a backup of an encrypted database to the same server it originated from, it's the same as any other restore because the certificate needed to decrypt it already...
February 15, 2011 at 11:18 am
Howard C. BAchtel-438731 (2/15/2011)
February 15, 2011 at 10:19 am
Before you implemented the fusionIO drive, did you verify that the server was actually IO bound so that you could expect to see an increase in performance?
If most of the...
February 14, 2011 at 10:05 pm
If you are copying a file to a share, the service account must have permissions to both the share and the underlying directory structure.
February 11, 2011 at 10:57 am
Maybe they will sign off a little faster once it stops working.
February 10, 2011 at 4:48 pm
Steve Jones - SSC Editor (2/9/2011)
BACKUP DATABASE MYDatabase to disk = 'c:\mybackup.bak'
runs to the C: drive on...
February 9, 2011 at 9:38 am
Viewing 15 posts - 961 through 975 (of 3,011 total)