SQL Server 2008 Full-Text Search feature can be used by application developers to execute full-text search queries against character based data residing in a SQL Server table
For JD Edwards customers: Get a preview of the must see sessions, demos, customer presentations and other highlights of OpenWorld 2008, September 21st - 25th in San Francisco. Register at: http://www.oracle.com/openworld/2008/index.html
For Siebel customers: Get a preview of the must see sessions, demos, customer presentations and other highlights of OpenWorld 2008, September 21st - 25th in San Francisco. Register at: http://www.oracle.com/openworld/2008/index.html
For E-Business Suite customers: Get a preview of the must see sessions, demos, customer presentations and other highlights of of OpenWorld 2008, September 21st - 25th in San Francisco. Register at: http://www.oracle.com/openworld/2008/index.html
For PeopleSoft customers: Get a preview of the must see sessions, demos, customer presentations and other highlights of of OpenWorld 2008, September 21st - 25th in San Francisco. Register at: http://www.oracle.com/openworld/2008/index.html
I've been monitoring failed logons to a server which is directly connected to the internet with no hardware firewall in the way...testing purposes only. Using the Server 2008 R2 firewall, I blocked access to just about everything except RDP, then I told the firewall to only allow connections to the RDP port from "MY" static IP. I tested from other locations and I am not able to login to the server unless i'm at my office. So how are people coming from Chinese IP's able to attempt logons and get logged as failures ?? Is there something i'm missing that needs to be blocked? Any help would be appreciated.
I am reading the SQL server 2008 bible and it says the materialized path pattern is significantly faster then the hierarchyid. Is this really true? How can I make the hierarchyid have equal or better performance.
I've just installed SQL Server 2008 Developer edition and I'm trying to connect using SQLCMD.exe, but I get the following error:
H:\>sqlcmd.exe -S ".\SQL2008"
Msg 18452, Level 14, State 1, Server DEVBOX\SQL2008, Line 1
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Has anyone seen this before? Any idea what it means??
Which database to decide upon? Any comparisions?
Existing: postgresql
Issues
Not easily scalable horizontal. Needs sharding etc
Clustering does not solve the data growth problem
Looking for: Any database that is easily horizontally scalable
Cassandra (Twitter uses that?)
MongoDB (rapidly gaining popularity)
Voldemart
Other?
Why?
Data growing with snowball effect
existing postgresql locks table etc for vaccuum tasks periodically
Archiving data is tideous currently
Human interaction involved in existing archive, vaccuum, ... process periodically
Need a 'set it. forget it. just add another server when data grows more.' type of solution
Hyper-V running under a fresh install of 2008 R2 DC
2 VMs both running 2008 R2 STD
One VM has SQL 2008 Server w/ SP2 and Office 2007 Enterprise w/ SP2
Othe VMS only Office 2007 w/ SP2.
Approximately 10 minutes after reboot the Hyuper-V host the VMs will hang
Hang = answers pings, but no RDP connections and Hyper-V console session is non responsive
Disabled Hyper-V and had no proble with 2008 R2 DC host.
Started the three Hyper-V services and 10 minutes later was hung again.
Hardware is HP DL380 G4 2 socket, 48 GB, Internal SAS controller 1.5TB C drive VMs .VHDs are on external SAS controller on a 1.5 TB RAID5 volume.
Nothing in event log on either VMs or Hyper-V host.
Ken
Hello everyone,
For Windows Server 2008 failover cluster, I find it is dependent on Windows domain (in other words, Windows domain is pre-requisite of installing Windows Server 2008 fail over cluster). I am not sure why it is dependent on Windows domain? What features of Windows domain will Windows Server 2008 failover cluster utilize?
thanks in advance,
George
http://www.codinghorror.com/blog/files/exported-font-and-colors-for-jeff-atwood-sept-19.zip
The Link is not working,
anybody has a mirror, or an export for VS 2008?
I'm using table values for the first time as a parameter to a function in SQL Server 2008. The code below produces this error:
Must declare the scalar variable "@RESULT".
Why?! I'm declaring it on the first line of the function!
ALTER FUNCTION f_Get_Total_Amount_Due(
@CUSTOMER_LIST [tpCSFM_CUSTOMER_SET_FOR_MONEY] READONLY
)
RETURNS [tpCSFM_CUSTOMER_SET_FOR_MONEY]
AS
BEGIN
--Prepare the return value, start with initial customer list
DECLARE @RESULT AS [tpCSFM_CUSTOMER_SET_FOR_MONEY]
INSERT INTO @RESULT SELECT * FROM @CUSTOMER_LIST
--Todo: populate with real values
UPDATE @RESULT SET tpCSAM_MONEY_VALUE = 100
--return total amounts as currency
RETURN @RESULT
END
I find myself going to about five or six main places in my code 80% of the time and would like a way to go to them fast even if all files are closed.
I would like to be able to open up a solution in visual studio and with no file open, see a list of self-labeled bookmarks like this:
LoadNext
Settings page refresh
app.config connections
app settings
stringhelpers top
stringhelpers bottom
I click one of these and it opens that file and jumps to that position.
How can I best make bookmarks like this in Visual Studio 2008/2010?
I'm working on building a computer (first time for me). There are several plugs that I need to connect to the motherboard (Power LED, reset switch, etc). Of the two wires, they are either:
Color and white (reset switch, power LED, HDD LED)
red and black (speaker, power switch)
The manual for the motherboard has a nice diagram of where to plug them in, but has them labeled + or -. Which colors are positive, and which are negative?
When I open DataSet in Visual Studio 2008 to design or modify it, it always take a very long time (more than five minutes) before I can continue to do my job. While I'm waiting I can't do anything on Visual Studio, moreover CPU and memory usage is growth dramatically.
I want to know, Is it has anyway to reduce this waiting time?
Hardware - Desktop
CPU: Intel Q6600
Memory: 4 GB
HDD: 320 GB 7200 rpm
OS: Windows XP 32 bit with Service Pack 3
I had Visual Studio 2010 beta 1 installed, and I removed. Now, when I try to crate a project in Visual Studio 2008. I get the error "MSBUildToolsPath is not specified for the ToolsVersion "4.0" defined at "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSBuild\TOolsVersions\4.0", or the value specified evaluates to the empty string". How do I change the ToolsVersion to "3.5", so it works?
In Windows Server 2008 and Windows 7 there are new Events categorized under "Applications and Services Logs". There is also a subfolder called Microsoft which has tons of subfolders as well.
Is there any way to collect these events through WMI? For the regular "Windows Logs" such as Application and Security, it is possible to use the Win32_NTLogEvent WMI class in the cimv2 namespace. However, this class does not provide access to the new Microsoft event logs.
Any ideas?
Hi all I am trying to store html and hyperlinks in my sql server 2008 database. I want to also be able to display the hyperlinks and render the html accordingly. I am trying to do this in ASP.NET MVC so I tried using HTTPUtility.HtmlEncode() method but didnt really store it thw way I wanted. So can anyone please guide me through the steps i need to take to achieve this.
Changing the entire question as earlier one was very confusing.
I have been exploring different clustering system to run Virtual machines on two different machines on LAN with high availability.
Currently I am already using DRBD resource on two different machines on Primary/Secondary mode. In case the primary fails I manually promote the secondary to Primary and start the VM.
I also explored Gluster and looks good, however, I would rather prefer clustering over Gluster (user space FS).
So if anyone has idea which one would be better from ease of use prospective please I would be interested in.
Moreover, sheepdog project appears good, however, could not find much documentations/Howtos.
I am using Centos 6.
While installing SCOM 07 R2 Database component on our DB server I get this error...
I've gotten the same error on the following configurations.
Windows Server 2003 & SQL Server 2008 SP1
Windows Server 2008 & SQL Server 2008 SP2
Is there any work around to Successfully install SQL server 2008 32-bit on Windows 7 Home premium 64-bit ?
If this is the case I first installed VS2008 SP 1 on my machine and when I click on install.exe file for installing SQL Server 2008 (Developer Edition) I get an error related to .NET Framework version which is installed already on my PC. { I get the same error trying to install Enterprise Edition}