Viewing 15 posts - 856 through 870 (of 961 total)
Another approach would be to get full backups on weekends and incremental backups EOD from the external vendor and ftp them to our site and have them restored to a...
June 21, 2011 at 5:17 am
could you define the columns e.g is product a subset of case is a subset of assembled?
Like Grant said business requirements will define the relationship between the columns and as...
June 21, 2011 at 5:11 am
whats the error you get when installing , is D drive a mapped network drive ? does it have enough space.
June 21, 2011 at 4:48 am
if trim doesnt work , chances are the spaces on the left are tabs
declare @name varchar(256)
set @name = '1231'
select ascii(SUBSTRING(@name , 1 , 1))
result
9
then do a replace to remove...
June 21, 2011 at 4:46 am
you need to copy the database files onto the disk of the machine hosting sql server. u cannot run sql database on protable media
June 21, 2011 at 4:35 am
Am sorry i should have mentioned this is a development environment.
June 21, 2011 at 4:31 am
From past experience I have seen the below issue , as a result i think it would be better to install SQL on its own drive.
The OS drive becomes full...
June 21, 2011 at 4:11 am
my guess would be student fees and attendance , fact tables are used for data that needs aggregation, in your case these are the only two tables i see. however...
June 21, 2011 at 3:41 am
GSquared (3/11/2009)
skjoldtc (3/11/2009)
So, if you ask a question of someone with a personality of null, do you get back a blank stare? Or, what?Yes.
Are Ansi nulls applicable ?
June 21, 2011 at 3:39 am
SQL Server can be setup in two ways , the first one is by clicking the install screens and specifying the required setup details. The second option is to perform...
June 21, 2011 at 3:22 am
Would it be acceptable to store the details as below
Username,
password ,
Lastloggedin,
usertype,
XML_userspecificdata
June 21, 2011 at 2:04 am
You will need to provide more information for us to help.
June 21, 2011 at 1:51 am
Check the output column properties of under advanced editor for the data source , else use a data conversion under the transformation tab.
DT_WSTR is for unicode.
June 21, 2011 at 1:41 am
Yes , look up silent install
http://blog.sqlauthority.com/2007/04/10/sql-server-2005-silent-installation-unattended-installation/
You will need to manually or automate the actual invocation of the installation process. Usually using an enterprise automation tool.
June 21, 2011 at 1:30 am
Query hints prevent the db engine from trying to optimize the query , using them tells SQLthe developer knows exactly what they are looking for. If your not sure do...
June 21, 2011 at 1:26 am
Viewing 15 posts - 856 through 870 (of 961 total)