Viewing 15 posts - 4,186 through 4,200 (of 8,416 total)
Garadin (4/5/2010)
There's nobody here with pitchforks scanning the hills for anybody daring to mention the Terms SSIS, SSAS, SSRS, DTS etc.
Absolutely no pitchforks here - I'm a big fan of...
April 6, 2010 at 12:53 am
Steve Jones - Editor (4/5/2010)
April 6, 2010 at 12:49 am
Gatekeeper (4/5/2010)
Seems like it would be better to have a table with the required columns rather than needing to write (UN)PIVOT queries.
Agreed - there are definitely opportunities to improve the...
April 6, 2010 at 12:46 am
Marts (4/5/2010)
One point I must note here, we have only sql server standard, and unless I'm very much mistaken it is limited to 2gb ram usage 🙁
Time to upgrade to...
April 5, 2010 at 12:54 pm
CirquedeSQLeil (4/5/2010)
That is true. Too much depends on the hardware. We are going through an exercise with EMC currently to optimize our SAN.
Cool! Which series/model? I...
April 5, 2010 at 12:40 pm
CirquedeSQLeil (4/5/2010)
April 5, 2010 at 12:30 pm
CirquedeSQLeil (4/5/2010)
April 5, 2010 at 12:16 pm
Steve Jones - Editor (4/5/2010)
I think from this entry (http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-12-Should-you-create-multiple-files-for-a-user-DB-on-a-multi-core-box.aspx) I'd say it might help.
Only if you are experiencing allocation contention - which can still happen on tempdb, but I...
April 5, 2010 at 12:07 pm
Marts (4/5/2010)
Currently it is on Windows server 2000, is there any benefit in changing to 2003?
Definitely, a big yes on that one, Martin.
Way too many reasons to list, but iSCSI...
April 5, 2010 at 11:54 am
CirquedeSQLeil (4/5/2010)
Paul White NZ (4/5/2010)
I still think it was the virus scanner :rolleyes:(joking!)
Maybe Zenoss had an identity crisis and tried performing virus scans:Whistling:
Heh...maybe 😛
April 5, 2010 at 11:35 am
I still have my original copy of the Commodore 64 programmer's reference guide, and a complete disassembly of the ROMs...
April 5, 2010 at 11:31 am
I still think it was the virus scanner :rolleyes:
(joking!)
April 5, 2010 at 11:28 am
Jeff Moden (4/5/2010)
April 5, 2010 at 11:26 am
Creating a column of type UNIQUEIDENTIFIER just defines the data type of values that can be stored in it. It does not enforce uniqueness.
NEWID and NEWSEQUENTIALID generate values of...
April 5, 2010 at 11:19 am
BSavoie (1/5/2010)
If it were called the Transaction Journal...
...I would expect to see it published monthly 😀
April 5, 2010 at 10:32 am
Viewing 15 posts - 4,186 through 4,200 (of 8,416 total)