text:
This action might not be possible to undo. Are you sure you want to continue?
user_name() 1> sp_helpdb to see databases 1> SELECT name, type FROM sysobjects WHERE type<>'S' to see tables in database 1> sp_helpdb dbname 1> sp_help 1> sp_help tablename to see table definition, field names 1> SELECT c.name to see table definition, field names 2> FROM syscolumns c, sysobjects o 3> WHERE o.name="table_name" 4> AND o.id = c.id 1> set rowcount 2 -- to limit number of rows 1> set rowcount 0 -- remove rowcount limitation 1> select * from sometable where 1=2 -- to see column names 1> vi -- to edit command 1>select name from sysobjects where type = "V" 1> quit How to change your password 1> sp_password old_password,new_password 2> GO How to list available databases 1> SELECT name FROM master..sysdatabases 2> GO How to select a database 1> USE database_name 2> GO How to list non-system tables in the database 1> SELECT name FROM sysobjects WHERE type='U' 2> GO How to list non-system-table objects in the database 1> SELECT name, type FROM sysobjects WHERE type<>'S' 2> GO How to list the column names of a table with data type (and some other junk) 1> sp_help table_name 2> GO How to list stored procedures in the database 1> SELECT name FROM sysobjects WHERE type='P' 2> GO How to display a stored procedure 1> sp_helptext stored_procedure_name 2> GO Here are useful help commands: select name from sysobjects where name like "sp_help%" name 1 sp_help 2 sp_help_rep_agent 3 sp_help_resource_limit 4 sp_helpartition 5 sp_helpcache 6 sp_helpconfig 7 sp_helpconstraint 8 sp_helpdb
9 sp_helpdevice 10 sp_helpextendedproc 11 sp_helpexternlogin 12 sp_helpgroup 13 sp_helpindex 14 sp_helpjoins 15 sp_helpkey 16 sp_helplanguage 17 sp_helplog 18 sp_helpobjectdef 19 sp_helpremotelogin 20 sp_helprotect 21 sp_helpsegment 22 sp_helpserver 23 sp_helpsort 24 sp_helptext 25 sp_helpthreshold 26 sp_helpuser select <column-list> from <table-name> select au_lname, au_fname from authors select title_id, type, price, price * .1 from titles select * from publishers (not recommended) string concatenation: select au_lname + ", " + au_fname from authors name ouput columns yourself - column alias select title_id, type, price "original price", price * .1 discount from titles select "Full Author Name" = au_lname +", " + au_fname from authors remove duplicates with distinct: select distinct type from titles select distinct city, state from authors (here distinct refers to a combination of city and state, so that each column by itself may have duplicate entries) filtering rows with where select <column-list> from <table-name> where <condition> select au_lname, au_fname from authors where state="CA" equality and inequality operators: = , <> or != , > , >= , < , <= , !< , !> select type, title_id, price from titles where price * total_sales < advance (can be applied to string comparison - default sorting order is ASCII) logical OR and AND select au_id, city, state from authors where state="CA" or city="Salt Lake City" between and Ranges of Data: <expression> between <expression> and <expression> select title_id, price from titles where price between $5 and $10 equivalent to select title_id, price from titles where price >= $5 and price <= $10 not between: select title_id, price from titles where price not between $5 and $10 equivalent to select title_id, price from titles where price >= $5 and price <= $10 in (...) : select title_id, price from titles where type in ("mod_cook", "trad_cook", "business") equivalent to
select title_id, price from titles where type = "mod_cook" or type = "trad_cook" or type = "business" not in (...) select title_id, price from titles where type not in ("mod_cook", "trad_cook", "business") wildcards with like: % - any number (0 to many) of any characters _ (underscore) - any single character [ ] any single character from those listed in the brackets (this is only for Sybase) [%[ - actually match the % character [^A-C] - matches any character except A,B,C select au_lname, au_fname, city, state from authors where city like "Spring%" select type, title_id, price from titles where title_id like "B_1342" select type, title_id, price from titles where title_id like "B[A-Za-z0]1342 Note - if you need to include the '_' character in your pattern - use 'escape' word, for example: select * from titles where title_id like 'ABC\_%' escape('\') ordering result sets with order by: select au_lname, au_fname from authors order by au_lname select au_lname, au_fname from authors order by au_lname, au_fname order by position in the select list: select title_id, price, total_sales, price*total_sales "total dollar sales" from titles order by 4 Ascending and Descending Ordering select title_id, price, total_sales, price*total_sales "total dollar sales" from titles order by price*total_sales desc default sort order is ascending. Example: sort by type (ascending) and then by total_sales (desc): select title_id, price, total_sales from titles order by type, total_sales desc order by columns not Appearing in the Select List: select au_lname, au_fname from authors order by city, state agregate functions: sum( ) - total numeric, avg( ) - average numeric, min( ) - lowest numeric or sorting string or earliest date, max( ) - highest numeric or sorting string or latest date, count( ) - returns the number of non-null expressions, count(*) - returns number of rows found select avg(price) from title select avg(price) "avg" from titles where type = "business" select avg(price) "avg", sum(price) "sum" from titles where type in ("business","mod_cook") counting rows with count(*): select count(*) from authors where state="CA" agregates functions discard null values sub-agregates with group by: select type, avg(price) "avg", sum(price) "sum" from titles where type in ("_business", "mod_cook") group by type When two or more columns are included in group by statement, agregates are based on unique combinations of these columns: select type, pub_id, avg(price) "avg", sum(price) "sum" from titles where type in ("_business", "mod_cook") group by type, pub_id
In order for aggregates to properly subtotal (or subaverage or subcount) by non-aggregate values, all non-aggregate columns in the select list should be repeated in the group by clause (see color above). Filtering results with having: where - selects rows before averaging: select type, avg(price) from titles where price > $10 group by type having select rows from the result set: select type, avg(price) from titles where price > $10 group by type having avg(price) > $20 Example: find duplicates of au_id: select au_id, count(*) from authors group by au_id having count(*) > 1 Worktable - a temporary table which is created before distinct, having or order by are applied. select type, avg(price) from titles where pub_id="1289" group by type having avg(price) > $15 order by avg(price) desc JOIN Operations: join using common key (or join key): select title, pub_name from titles, publishers where titles.pub_id = publishers.pub_id select au_lname, au_fname, title from authors a, titles t, titleauthor ta where ta.title_id = t.title.id and a.au_id = ta.au_id and type="psychology" select t.*, pub_name from titles t, publishers p where t.pub_id = p.pub_id Outer join: left (*=) or right (=*): select pub_name, title from publishers p, titles t where p.pub_id *= t.pub_id This query retrieves all pub_names from publishers. For any row that doesn't join successfully with titles, the title column will contain a null for that row in the output. Subqueries - to be used instead of a constant: select title from titles where pub_id = ( select pub_id from publishers where pub_name = "Algodata Infosystems") Subqueries with IN (or NOT IN) can return multiple rows: select pub_name from publishers where pub_id in (select pub_id from titles where type = "business") subquery can be rewritten as a JOIN: select pub_name from publishers p, titles t where p.pub_id = t.pub_id and type = "business" Subqueries with exists - the best way to eliminate duplicates: select pub_name from publishers p where exists (select * from titles t where p.pub_id = t.pub_id and type = "business") not exists and not in : select pub_name from publishers p where not exists (select * from titles t where p.pub_id = t.pub_id and type = "business")
select pub_name from publishers where pub_id not in (select pub_id from titles where type = "business") Subqueries with agregates in the where clauses: select type, price from titles where price < (select avg(price) from titles) union operations: select city, state from authors union select city, state from publishers (duplicates will be automatically removed from the result unless you use union all ) Here is one more example: select 95 "year", month, sum(dollar_sales) from salescurrent group by month union select 94 "year", month, sum(dollar_sales) from salescurrent group by month order by year, month Using select into insert, update, delete: creates a table on the fly instead of returning the the output to the user: select distinct type into type_lookup from titles Example: create an empty copy of an existing table: select * into new_salesdetail from salesdetail where 1 = 2 Adding rows with insert: insert authors (au_id, au_lname, au_fname, phone) values ("123-45-6789","Jones","Mary","212-555-1212") Columns that are not specified will be set to their default values If you don't specify column names at all (which is very bad practice and dangerous) - then you have to provide values for ALL columns an in the right order: insert publishers values ("1235","New World Printing","GA","Atlanta") inserting several rows with select: insert authors_archive (au_id, au_lname, au_fname, phone, city, state, zip) select au_id, au_lname, au_fname, phone, city, state, zip from authors where state="CA" modifying rows with update: update publishers set pub_name = "Joe's Press" where pub_id = "1234" Example: update based on a join: update titles set full_name = isnull(u.full_name,'') from db1..titles tit, db2..users u where tit.kid *= u.kid Example: double all prices in the table: update titles set price=price*2 update several columns simultaneously: update contacts
set address1 = "5 W. Main St.", address2 = "Apt.3D", state="CT", zip="03838" where contract_id = 17938 remove rows with delete: delete titles where type = "business" Clearing the table: delete title or truncate table titles truncate is faster, but it doesn't log individual deletions - thus the ability to recover database is compromised. Datatypes: Once you create a column of certain datatype - you can not change it without dropping and re-creating the table create table my_table ( id int not null value float not null description varchar(30) null ) Storing strings: char - fixed length strings (max length - 255) varchar - variable-length strings (max length - 255) nchar - multi-byte character strings nvarchar - variable-length multi-byte char strings text - for very large strings (up to 2 GB of text per row) Storing binary data: binary - for fixed-length binary strings varbinary - for variable-length binary strings image - for storing large binary strings (up to 2 GB of image data per row) insert b_table (id, bin_col) values (19, 0xa134c2ff) using timestamp: create table timestamp_example ( id int not null, code char(3) not null, ts timestamp not null ) insert timestamp_example (id, code) values (17, "AAA") The server uses the uniquetransaction-log-row id as a timestamp. You can not specify this value. Optimistic locking (page 75): using tsequal() function to check the locking Storing BLOBs (binary large objects) using text and image datatypes: create table texts ( id numeric(5,0) identity, item int not null, textstring text null ) using insert: insert texts (item, textstring) values (1, null) insert texts (item, textstring) values (2) insert texts (item, textstring) values (3, "some text") insert texts (item, textstring) values (4, "some very long text") insert statement will not insert more than 1,200 bytes. string concatenation on strings longer than 255 chars is illegal
using writetext and readtext: The idea is to get the pointer to the text chain and to write directly to this chain without modifying the underlying row. To do this you should start with a non-null popinter stored in the row itself. Here is how to retrieve the pointer for a row: select id, textptr(textstring) textptr, datalength(textstring) datalength from texts to write a new textstring value to the 3rd row: declare @pageptr varbinary(16) select @pageptr = textptr(textstring) from texts where id = 3 writetext texts.textstring @pageptr "some very long string" to read 50 bytes starting from position 4000: declare @pageptr varbinary(16) select @pageptr = textptr(textstring) from texts where id = 3 readtext texts.textstring @pageptr 4000 50 textstring Date/Time datatypes: datetime (3 millisecons, 8 bytes) smalldatetime (1 min, 4 bytes) create table date_example ( id int not null dateval datetime not null) insert date_example (id, dateval) values (19, "September 25, 1996 3:15PM") you can use other forms of format, for example: 4/15/99 select * from date_table where date = "9/3/95" select * from date_table where date >= "9/3/95" and date < "9/4/95" timestamp - a binary, ticks of some sort, it is not datetime drop table #test create table #test ( id numeric(18,0) identity, ts timestamp, dt datetime, sm smalldatetime ) insert #test(dt,sm) values (getdate(), getdate()) select * from #test datediff(dd,"15-Apr-2000","15-Apr-2001") - returns '365' where LastActivityDate > dateadd(yy,-2,getdate()) where LastActivityDate > dateadd(dd, -90, getdate()) Logical datatype: bit - can not be indexed and can not be null: create table bit_sample (id int not null, description varchar(30) null, active bit not null) Numeric datatypes: int - 4 bytes signed smallint - 2 bytes signed tinyint - unsigned byte (0..255) float - 8 bytes real - 4 bytes numeric(7,2) - you can indicate total number of digits and number of digits after decimal point. Can be used with identity (automatic counter) decimal - similar to numeric, but can't be used with identity
money - 8 bytes smallmoney - 4 bytes (+/-214,748.3647) create table numeric_example ( id numeric(8,0) identity, num_col numeric(7,2)) insert dollar_table (id, dollars) values (95, $12345.93) ======================================================== ======== create table table_name ( ...) drop table table_name sp_help sp_help table_name object's full name: database_name.owner_name.object_name pubs.dbo.authors Columns can have following properties: Null, Not null, Identity Views - logical way of looking at data (you can treat them as tables): create view author_name as select last = au_lname, first = au_fname from authors select * from author_name drop view author_name * note: dropping a view doesn't change data * views - help security by limiting access to tables * views - help make queries simpler * views can contain aggregate functions and grouping, joins, other views and a distinct clause. * views CAN NOT include "select into" , a compute clause, a union clause, and "order by" clause. * You can insert into, update and delete from views (restriction: allowed to affect only one base table). * If view includes columns from several tables, you can't delete rows from view or update columns from more than 1 table in a single update statement * You can not update, delete or insert into a view containing the distinct clause. sp_help - lists all objects (including tables and views) to get a list of just the views: select name from sysobjects where type = "V" to see a list of columns in a view: sp_help view_name Renaming objects (tables, views, columns.) using sp_rename: sp_rename old_name new_name sp_rename 'table_name.old_col_name' , 'new_col_name' Adding columns to a table using alter: alter table tt add middle_name varchar(20) null, fax varchar(15) null NOTE: You can only add columns with null values. NOTE: You can't remove columns using alter. You have to recreate the table and indexes and insert data again, for example: create table lev1 (c1 int not null,c2 int null) CREATE UNIQUE CLUSTERED INDEX lev1_idx ON lev1(c1) CREATE NONCLUSTERED INDEX lev1_qib_idx ON lev1(c1,c2) insert lev1 values (1,2)
insert lev1 values (2,2) insert lev1 values (3,2) ------- add columns ----------------alter table lev1 add c3 int null, c4 int null ------- remove columns ------------exec sp_rename 'lev1','lev1_tmp' -- sp_rename 'lev1_tmp.lev1_idx', 'lev1_tmp_idx' -- sp_rename 'lev1_tmp.lev1_qib_idx', 'lev1_tmp_qib_idx' create table lev1 (c1 int null, c2 int null) CREATE UNIQUE CLUSTERED INDEX lev1_idx ON lev1(c1) CREATE NONCLUSTERED INDEX lev1_qib_idx ON lev1(c1,c2) insert into lev1 select c1,c2 from lev1_tmp drop table lev1_tmp -- this will automatically drop indexes Temporary Tables - are real tables created in the tempdb database. They have '#' before table name. They exist only for the duration of a user session (or stored procedure) and only accessible to this session. These tables are not recoverable (in case of a crush). select au_lname, au_fname, title, pub_id into #titles_and_authors from authors a, titleauthor ta, titles t where a.au_id = ta.au_id and t.title_id = ta.title_id Creating permanent Temporary table in tempdb: select * into tempdb..titles from pubs2..titles Rules: create rule order_quantity as @quantity between 100 and 150000 create rule color_rule as @color in ('black', 'brown', 'red') create rule pub_id_rule as @pubid like ('99[0-9][0-9]') or @pubid in ('0736', '0877', '1389') create rule date_rule as @date >= getdate() drop rule key_rule Binding rule to a column: sp_bindrule rule_name, 'table.column_name' sp_unbindrule 'table.column_name' Defaults: create default country_default as 'USA' create default age_default as 16 create default time_default as getdate( ) binding default to columns in a table: sp_binddefault default_name, 'table.column_name' sp_bindefault country_default, 'demographics.country' sp_unbindefault 'demographics.country' you can define default for a column when you create a table. later you can change it using later table: alter table items replace price default null alter table items replace item_code default "N/A"
To list all rules and defaults in a database: select name from sysobjects where type in ("R", "D") To examine the rules and defaults bound to the column in a table: sp_help table_name sp_helptext object_name Creating User-defined Datatypes: sp_addtype ssn_type, 'char(9)', "not null" Indexes: 2 types of indexes - clustered and nonclustered. Both are B-tree. Clustered - only one clustered index per table can exist (data is maintained in clustered index order). Nonclustered indexes - you can have 249 of them per table. They maintain pointers to rows (not data pages). An index can contain up to 16 columns, but toal index width <= 255. Creating indexes: create unique clustered index name_index on authors (au_lname, au_fname) create index fname_index on authors (au_fname, au_lname) ***********************Constraints: Primary Key and Unique Constraints Check Constraints Referential-integrity Constraints Primary-Key Constraints Foreign-Key Constraints Modifying Constraints Adding Constraints Removing Constraints Information on Constraints: sp_helpconstraint ***********************Comparing Data-integrity Methods: Rules, Defaults, Indexes, Constraints, Keys (Primary Key, Foreign Key (primary key from another table), Common key) T-SQL programming constructs: standard arithmetic operations ( + - * / ^) string functions: datalength(), substring(), right(), upper(), lower(), space(), replicate(), stuff(), reverse(), ltrim(), rtrim(), ascii(), char(), str(), soundex(), difference(), charindex(), patindex() note: to include quotes into string you can repeat it 2 times (or one time if the surrounding quote is of different type): " "" " ' '' ' " ' " ' " ' 'I don''t know' "I don't know" " Title ""The Title"" was on sale" ' Title "The Title" was on sale' math.functions: abs(), ceiling(), exp(), floor(), pi(), power(), rand(), round(), sign(), sqrt() date functions: getdate(), datename(), datepart(), datediff(), dateadd() convert - to convert data types: select "Advance = " + convert (char(12), advance) from titles (can also convert dates) system functions: host_id(), host_name(), suser_id(), suser_name(), user_id(), user_name(), user, show_role(), db_id(), db_name(), object_id(), object_name(), col_name(), col_length(), index_col(), valid_name(), datalength(), tsequal()
compute, compute by: allows to include both detail and summary info in a single result set isnull - function tells to treat null values as zero or something else. Batches: several commands followed by 'go' command Comments: /* */ or * Local variables: declare @variable_name datatype declare @myname varchar(30), @type int select @myname=12 go note: name length is limited to 30 char (including @) Global variables - can not be defined by users. (examples: @@rowcount, @@error, @@trancount, @@transtate, ...) Message handling: print "this is a message" declare @msg varchar(30) select @msg = "Hello " + user_name() print @msg Error handling: raiserror 52345 'Row not found' if .. else: if (select ...) print "sometext" else print "some_other_text" while: while(select ...) begin update ... continue break end goto: metka: select ... ... goto metka waitfor: waitfor time "22:00:00" while 1<2 begin waitfor delay "00:00:30" exec sp_who end return: to exit the batch set: set rowcount 100 set statistics time on set nocount on ... Cursors - allow custom processing for each row: declare leads_curs cursor for select cust_id, ets-sale from leads for read only go
open leads_curs while () begin .. end close leads_curs deallocate leads_curs go You can do also custom updating with cursors. In general you should avoid cursors - try to substitute them sith complex select statements (usually will run x10 faster) Triggers: create trigger titles_trigger on titles for insert as print "title inserted" return ***************drop trigger trigger_name ***************create trigger cascade_del_trigger on publishers for delete as if @@rowcount = 0 * no rows deleted, exit trigger return delete titles from titles t, deleted d where t.pub_id = d.pub_id if @@error != 0 begin print "Error occurred during deleting related titles" end return ***************create trigger tr1 on ... for insert, update as declare @rows int select @rows = @@rowcount ... if (.. ) ... ***************In triggers you CAN NOT do these: create, drop, alter table/database, grant, revoke, select into, truncate table, update statistics, reconfigure, load database/transaction, disk init/mirror/reinit/refit/remirror/unmirror ***************Triggers During transactions: ... begin tran add_titles insert ... insert ... commit tran ***************rollback trigger - command to rollback the trigger Nested Triggers - 16 levels of nesting max Stored Procedures: * faster (precompiled in memory) * reduced network traffic
* modular programming * restricted access to tables * reduced operator error * enforced consistency * automated complex or sensitive transactions ***************create proc pub_titles as select .. from ... where ... return To execute a stored procedure: call by name if it is a first command in the batch or use "exec" (or "execute" command): exec proc_name To delete the procedure: drop proc proc_name To change the procedure: if exists (select * from sysobjects where name = "titles_for_a_pub" and type = "P" and uid=user_id()) drop proc titles_for_a_pub go create proc titles_for_a_pub as ... To display the text of the procedure: sp_helptext proc_name passing parameters: create proc tt (@pub_name varchar(40)) as select ...where ... return declare @my_pname varchar(40) select @my_pname ="Some text" exec tt @my_pname Default Parameter Values: create proc proc_name p_name datatype = default_value , .... as SQL Statements return ... ----- Output parameters: create proc tt ( @par1 varchar(80) = null, @par2 int output) as -- some T-SQL statements go here return declare @myoutput int exec tt @par1 = 'sometext', @par2 = @myoutput output go ----- Returning procedure status: return some_int_value 0 - no errors *1 .. -99 - detected errors (page 194 - list of error status codes) other values - whatever you like declare @staatus_var int exec @staatus_var = proc_name Note: A stored procedure may NOT: create views, defaults, rules, triggers or procedures, or issue the use statement Note: If stored procedure references a table, and the table was changed - you may have to
drop procedure, change it and re-create it. When created, stored procedure is transformed into a cashed sequenced of SQL statements. If procedure has "with recompile" - it forces the optimizer to generate a new query plan for each execution. ----- Returning data from one SP into a caller-SP: --------------------------------------- transparent passing the result value ----------------------------------create proc test1 as select count(1) N from OE create proc test2 as exec test1 exec test2 --------------------------------------- catch the output value in the caller SP: ----------------------------------create proc test3(@a int, @b int output) as select @b = @a*@a create proc test4 as begin declare @par_in int declare @par_out int declare @ret_status int select @par_in = 3 exec @ret_status = test3 @par_in, @par_out output if not @ret_status=0 begin select @par_out = 0 end select @par_out select @par_out+1 end exec test4 --------------------------------------- transparent passing the result set ----------------------------------create proc test5 as select * from mytab create proc test6 as exec test5 exec test6 --------------------------------------- handling errors, transactions ----------------------------------create proc mysp as begin declare @tran_cnt int declare @errs int declare @rows int select @tran_cnt = @@trancount if @tran_cnt = 0 begin transaction mytran else save transaction mytran -- do something useful -- then check for errors select @errs = @@error if (@errs != 0) begin rollback transaction sbl_upd_ticker return @errs end select @loc=loc, @idx=idx from mytab if not @@rowcount=1
begin rollback transaction mytran raiserror 30200 return 30200 end if @tran_cnt = 0 commit transaction mytran select @my_id = (@loc * 10000000) + @idx return 0 end Objects referenced in a procedure: exec sp_depends proc_name exec sp_depends table_name Transactions - several statements grouped together and either commited or rollbacked all together (all individual steps are recorded into a transaction log for recovery in case of a crash) begin tran save tran rollback tran commit tran set chained @@tranchained 0 - chained mode is off, 1 - chained mode is on begin transaction update something insert something if ... begin ... commit transaction end else begin ... rollback transaction end Note: transactions put locks on pages (2K blocks of data) savepoints inside transaction: save tran item999 ... rollback tran item999 Nested Transactions: @@trancount stored procedure with a transaction inside create proc p1 as declare @trncnt int select @trncnt = @@trancount -- save value if @trncnt = 0 begin tran p1 else save tran p1 /* do some work here */ if (@@transtate = 2) -- or other error condition begin rollback tran p1 return 25 -- error code indicating rollback end /* some more processing if required */
if @trncnt = 0 commit tran p1 return 0 -- success nesting transactions - batch with transaction calls a stored procedure with a transaction inside ..... declare @status_val int, @trncnt int select @trncnt = @@trancount -- save value if @trncnt = 0 begin tran t1 else save tran t1 /* do some work here */ if (@@transtate = 2) -- or other error condition begin rollback tran t1 return -- exit batch end execute @status_val = p1 -- call procedure with transaction from inside transaction - thus nesting transactions if @status_val = 25 -- if proc p1 performed rollback begin rollback tran t1 return end if @trncnt = 0 commit tran t1 -- decrements @@trancount to 0 return triggers may be part of a transaction: begin tran update titles set price=$99 where title_id = "BU1234" commit tran rollback transaction in a trigger rollback trigger chained transactions - eliminates transaction nesting Getting info from sys. tables some examples using sys tables -------------------------------------------------------select name from sysobjects where sysstat & 7 = 3 order by name -------------------------------------------------------select rowcnt(t2.doampg), (reserved_pgs(t2.id, t2.doampg) + reserved_pgs(t2.id,t2.ioampg)), (t3.low), data_pgs(t2.id, t2.doampg), data_pgs(t2.id,t2.ioampg), ( (reserved_pgs(t2.id, t2.doampg) + reserved_pgs(t2.id,t2.ioampg)) (data_pgs(t2.id, t2.doampg) + data_pgs(t2.id,t2.ioampg)) ) from sysobjects t1, sysindexes t2, master.dbo.spt_values t3 where t2.id = object_id('myTableName') and t1.id = object_id('myTableName')
and t3.number = 1 and t3.type = 'E' ------------------------------------------------------select t1.name, t2.name, t1.length, t1.status from syscolumns t1, systypes t2 where t1.id = object_id('my_name') and t1.usertype *= t2.usertype -------------------------------------------------------select t1.indid, t1.name from sysindexes t1 where t1.id = object_id('my_name') and t1.indid > 0 and t1.indid < 255 -------------------------------------------------------select index_col('my_name', indid_buf, keyid_buf, ...) -------------------------------------------------------select t1.name from master.dbo.spt_values t1, sysindexes t2 where t2.status & t1.number = t1.number and t2.id = object_id('my_name') and t2.indid = my_some_indid_buf and t1.type = 'I' and t1.number = 2 -------------------------------------------------------select t1.name from syssegments t1, sysindexes t2 where t1.segment = t2.segment and t2.id = object_id('my_name') and t2.indid = my_some_indid_buf -------------------------------------------------------select replstat = convert(bit, (t1.sysstat & -32768)) from sysobjects t1 where t1.id = object_id('my_name') -------------------------------------------------------Stored procedure with a cursor if exists (select 1 from sysobjects where name = "myname") drop proc myname go create proc myname as begin declare @my_id int declare @root_my_id int declare mycursor cursor for (select my_id from MT) open mycursor fetch mycursor into @my_id while ((@@sqlstatus = 0)) begin exec @root_my_id = MT_get_root @my_id insert into MT_root_map_tmp (my_id, root_my_id) values (@my_id, @root_my_id) fetch mycursor into @my_id end close mycursor deallocate cursor mycursor end
go script to copy data between databases You can copy data between databases using migrate utility in DBArtisan. Or you can use this script (it accepts table name as a parameter): #!/bin/sh -v if [ $# != 1 ] then echo "Usage: $0 <table>" exit 1 fi table=$1 PROD="-S SERV1 -U user1 -P pass1" DEV="-S SERV2 -U user2 -P pass2" bcp mydb..$table out $table.dat $PROD -n > /dev/null isql $DEV -w250 <<EOF use mydb go delete $table go EOF bcp mydb..$table in $table.dat $DEV -n > /dev/null isql $DEV -w250 <<EOF use mydb go update statistics $table go EOF Misc: count distinct types: select dept, count(*) from mytable where dept is null group by dept union select distinct dept, count(*) from mytable where dept is not null group by dept when you joining tables - they join only on not null values. The common situation is joining 2 tables through a middle table which maps keys between the side 2 tables. This works good for normal inner joins: select ... where A.x = B.x and B.y = C.y But what if you want all values from A - and just fill with nulls other columns. You try left join - but it doesn' work: select ... where A.x = B.x and B.y = C.y -- doesn't work You can either do it in 2 steps (make a temporary table) - or use union: Getting date difference as part of the year in Sybase
select distinct dept, count(isnull(dept,'0')) from mytable group by isnull(dept,'0')
example of a union: select #t1.* from #t1,#t2 where #t1.bb = #t2.bb union select t1.* from #t1 t1 where not exists ( select * from #t2 t2 where t1.bb = t2.bb )
-- select convert(numeric(6,2), datediff(mm, '4/1/02', '1/1/03'))/12.00 -- select convert(numeric(6,2), datediff( dy, '4/1/02', '1/1/03' ))/365.00 -- select convert(numeric(6,2), datediff( dy, '4/1/02', '7/1/02' ))/365.00 Catching special characters: select count(*) from mytab where charindex(char(10), myname) !=0 The simple way to find all occurencies of special characters is to use a short perl script. Below is the code (do_query is a self-made subroutine returning the result set as an array of hashes): my ($sql,$result,$row,$oe_id,$name,@ar,%hh); $sql = qq{ select id, name from mytab where name like '%[^0-9A-Za-z -_.,''""%]%' }; $result = &do_query($dbh, $sql); for $row (@$result) { $id = $row->{id}; $name = $row->{name}; @ar = unpack('C*', $name); %hh = (); for(@ar) {if($_<32 or $_>127){$hh{$_}++}} for(sort keys %hh){print"id <$id>: code $_ - $hh{$_} times\n"} } Using 'union' to do logical operations in single statement without creating temporary tables: Let's say we have a table with 2 columns (a,b): create table #t (a int null, b int null) insert #t (a,b) values (-1,6) insert #t (a,b) values (0,5) insert #t (a,b) values (1,4) insert #t (a,b) values (2,3) insert #t (a,b) values (3,2) and we want to return max(a) or max(b) depending on which one is larger. Here is how this could be done select max(b) mm from #t having max(b) > (select max(a) from #t) union select max(a) mm from #t having max(b) > (select max(b) from #t) Tune your SQL Query Tuning Options set forceplan on - forces SQL Server to join the tables in a query in the order in which they are listed in the from clause. set table count - allows you to specify the number of tables that are considered at once as joins are optimized. sp_cachestrategy - disables and reenables cache strategies and large I/O for individual objects. specify the index, cache strategy, or I/O size for a query (for example: select * from mytab (index mytab_idx) where ...) set prefetch - allows you to enable or disable large I/O for a session.
Benchmarking your query: set statistics time on set statistics IO on by hand Help your optimizer to make sure it has correct information about your table and uses it for queries and stored procedures. This info may me incorrect, for example, after bulk loads: update statistics tabname sp_recompile tabname Examine the showplan of your query: set showplan on go set noexec on go or for a stored procedure set showplan on go set fmtonly on go Note: do not mix set noexec & set fmtonly Run your code - examine the output - look where table scans are made instead of using indexes. Sometimes index is not used because: - it doesn't exist on the column used in the where clause or in a join - there is a datatype mismatch in the join (like integer joined to numeric) - if the query is not restrictive enough and returns significant portion of the table. The optimizer then will choose to use table scan. - the indexes are very complex - so Optimizer decides that it is less costly to just read the table itself - some where cluases may cause problems: order by, group by, having, between, like, calculations in where clauses. - sometimes table scan is really more effective and you don't need to eliminate it. Note, that database can cashes data, so repeating the query may get the results faster. Simple solution - vary the query. dbcc traceon(302, 310, 3604) sp_sysmon etc.
This action might not be possible to undo. Are you sure you want to continue?
We've moved you to where you read on your other device.
Get the full title to continue listening from where you left off, or restart the preview.


text:
Many boaters ignore new fee at boat launch
Published: Monday, July 22, 2002 at 6:01 a.m.
Last Modified: Sunday, July 21, 2002 at 11:00 p.m.
BAYOU BLACK -- Clear skies and temperatures in the mid-90s attracted many area residents to the water Friday.
For Tommy Bascle of Houma, that meant launching his boat at Cannon's Boat Landing along Big Bayou Black and making his way across the Intracoastal Waterway.
Before the boat hit the water, Bascle did something many boaters using Cannon's Landing have not done lately: He paid the $5 launch fee.
The fee went into effect June 10 and is collected by Terrebonne Parish Recreation District No. 9, which now owns and maintains the landing.
"It's my understanding that it's the most expensive launch in the parish," Bascle said. "For it to be fully self-serve like it is, I find (the $5) steep."
Joe Boudreaux, another Friday-afternoon boater, said he opposes the fee.
"If it's public, I don't think there should be a fee on it," said Boudreaux, a Houma resident. "It's another par for the administration in office right now."
Outdoorsmen cried foul in June 2001 when Cannon's Landing closed after nearly 20 years of operation. The landing had been owned by the Cannon family, which also owned adjacent Louisiana Compressor Maintenance. However, Houston-based Universal Compressor acquired LCM last year and closed the launch.
The Cannons then donated the launch and land to Terrebonne Parish, which performed $8,500 worth of repairs and donated it to the nearby public recreation district.
The launch first reopened in November and was free until last month.
Lee Hunt, the recreation district's director, said most boaters do pay the fee, but many just ignore it.
"We're doing the best we can, but it's hard to enforce," Hunt said of collecting the launch fee. "We have been getting complaints, and some people aren't paying out of pure meanness."
The recreation district offers annual launch tickets for $100 instead of the $5 per-launch fee. The fee is now collected on a type of honor system. Boaters must obtain an envelope from a wooden box, fill out the ticket, enclose $5, place a receipt on their vehicle and drop the envelope in a box.
Hunt said he checks periodically for tickets on vehicles in the launch parking lot.
"We've given out quite a few warnings but no fines yet," he said.
The fine would be $50, levied by the Terrebonne Parish Sheriff's Office, Hunt said.
Recreation district officials said they understand boaters' gripes about the fee but feel those upset do not understand the district's plight, which lies mostly in liability-insurance costs.
Hunt explained the district pays into the parish's insurance plan but would be forced to pay a $500,000 deductible for a large claim.
"That would break us," Hunt said. "So we purchased a $500,000 policy to cover any possible deductible. Part of the launch fee is covering the cost of the insurance policy."
Hunt said recreation district revenue for the launch has fallen short so far.
"I bought 500, $100-decals," Hunt said. "We haven't sold 10 yet. I don't think it was a bad idea; I just don't think it caught on yet."
Some of the money raised through the annual decals and daily fees would go toward landing improvements, as well.
Hunt said preliminary plans include the construction of a vending machine portal, dock and bulkhead extensions, additional lighting and other improvements.
Upkeep and maintenance is also difficult now because money for the landing was not included in the district's current annual budget.
Hunt said he hopes many boaters, like Bascle, will come to understand the recreation district's needs.
"I don't really mind paying it because it is a convenient launch," Bascle said. "I'm glad it's here; I just think it is a little steep."
Matt Gresham is a staff writer for The Courier. He can be reached at 857-2204 or by e-mail at firstname.lastname@example.com.
Reader comments posted to this article may be published in our print edition. All rights reserved. This copyrighted material may not be re-published without permission. Links are encouraged.
Comments are currently unavailable on this article

subset: commoncrawl


text: Home Gallery Video Ask.com Animal in Pants Ask.com: Animal in Pants Published on Mar 23, 2006 Editor's Pick Rate this Ad You must be registered to rate the ad. Please Login or Register Now About CreditsDateMar 23, 2006Production Company:HarvestPost Production:PLANKVFX:The SyndicateClient:Ask.comSound Designer:Craig HelmholzExecutive Producer:Bonnie GoldfarbExecutive Creative Director:Chuck McBrideCreative Director:Joe KayserArt Director:Lauren HarwellCopywriter:Jaime RobinsonAgency Executive Producer:Jennifer GolubAgency Producer:Joe CalabreseDirector:Baker SmithDirector of Photography:John ZillesEditor:Catherine BullVFX Supervisor:Kevin PrendivilleAgency:TBWA/Chiat/Day San Francisco Latest Creativity News on Ad Age John Cena's Pecs Do All the Talking in Hefty's New Ad How Ben & Jerry's Keeps Purpose Alive Forget Dogs, Little Caesars Wins Best in Show for Pizza Advertisement Ad Age Creativity $142.5B 2015 U.S. ad spending for 200 LNA Learn more Related work Ask.com: Ask Deals Ask.com: Ask Deals (TV) Ask.com: Cop Hanft Raboy & Partners New York Want to see your work in our gallery? Submit now


text:
Samsung Cetus caught in Microsoft video
We've still yet to hear anything official from Samsung or Microsoft about the Samsung Cetus and it's Windows Phone 7 credentials, however that hasn't stopped the phone popping up over and over again for us to get a good glimpse of.
The latest unofficial outing for the Samsung Windows Phone 7 smartphone is a Channel 9 behind the scenes video telling you what some of the key players do on the new OS from Microsoft.
15 minutes in to the 17 minute video and Charlie Kindel, program manager for Windows Phone 7 whips out his phone to show a home automation application he has created for himself to help test some of the operating systems features.
Trouble is, as WMpoweruser.com spotted, the phone looks rather like the Samsung Cetus i917 handset rather than just the developers unit that we've already seen - Opps.
Sources have previous confirmed to Pocket-lint that Microsoft is expected to announce the launch of Windows Phone 7 to the world on 11 October with handsets from companies like Samsung launching their handset shortly after towards the end of October.
We will keep you posted.
- Windows Phone 7 launch phones: The complete rumoured line-up
Best smartphones 2016: The best phones available to buy today
Samsung Galaxy S7 and Galaxy S7 edge: Release date, specs and everything you...
LG G5: Release date, price, specs and everything you need to know
Samsung fixes Galaxy S7 Active's waterproof flaw, will replace phones
- Next Nexus (2016): Release date, rumours and everything you need to know
- Samsung fixes Galaxy S7 Active's waterproof flaw, will replace phones
- Samsung Galaxy Note 7 vs Apple iPhone 6S Plus: What's the rumoured difference?
- BlackBerry Hamburg/Neon: Release date, specs and everything we know so far
- Apple iPhone 7 Plus vs iPhone 6S Plus vs iPhone 6 Plus: What's the rumoured difference?
- Pokemon Go Gym tips: How to battle, train and win
- Help! Pokemon Go isn't working: How to fix common Pokemon Go problems
- Pokemon Go: How to play and other tips and tricks
- Next Nexus (2016): Release date, rumours and everything you need to know
- What is Prisma and how does it work? Explaining the Android and iOS app


text:
South San Francisco J W Smog Test Only
G8 Smog Test Only
265 San Bruno Ave E, San Bruno, CA 94066
- (650) 871-8483
1. G8 Smog Test OnlyServices
265 San Bruno Ave ESan Bruno, CA 94066
From Business: G8 Smog was established in 2006, our certified technicians have been in the automotive industry for many years and are very knowledgable in what they do. We pride o…
2. A1 Test Only Smog CenterServices
236 El Camino RealSan Bruno, CA 94066
3. Smog Depot Test Only
7651 El Camino RealColma, CA 94014
4. Smog Depot Test Only
7651 El Camino RealDaly City, CA 94014
5. Oceana Smog Test Only Center
100 Milagra DrPacifica, CA 94044
6. 19th Ave. Smog Test Only
1101 Junipero Serra BlvdSan Francisco, CA 94132
From Business: WE HAVE BEEN IN THIS BUSINESS SINCE 1989 AND OVER 19 YEARS AT THIS LOCATION
7. Millbrae Test Only SmogServices
120 El Camino RealMillbrae, CA 94030
From Business: Bring Your Vehicle To Our Smog Test Only Shop IN San Bruno Or Millbrae, For Affordable Emissions And Smog Testing Service. Serving The Local Community For Eight Yea…
8. Colma Smog Test Only Center
4698 Callan BlvdDaly City, CA 94015
9. Smog Depot Test Only
1690 Sullivan AveDaly City, CA 94015
10. Golden Gate Smog Test Only
2399 19th AveSan Francisco, CA 94116
11. Smog Queen Test Only Station
2399 Market StSan Francisco, CA 94114
12. Santiago Smog Test Only
Santiago Smog Test is at the corner of South Van Ness and Cesar Chavez in San Francisco, within the Flyers Gas Station. Paul Santiago is gregario…
13. San Francisco Test Only Smog 1
388 Potrero AveSan Francisco, CA 94103
14. SF Smog Test Only Station
2399 Market StSan Francisco, CA 94114
15. San Francisco Smog Test Only
300 5th StSan Francisco, CA 94107
16. Belmont Smog Test Only
230 Old County RdBelmont, CA 94002
17. Smog Queen Test Only
I took my high-end temperamental Italian sports car to them and they treated it as if it was their own baby. They were fast, efficient, friendly, kn…
18. Downtown Smog Test Only
941 Geary StSan Francisco, CA 94109
19. Bay City Smog Test OnlyServices
4850 Geary BlvdSan Francisco, CA 94118
20. Folsom Smog Test Only
1379 Folsom StSan Francisco, CA 94103
21. 21st Avenue Smog Test Only
71 E 21st AveSan Mateo, CA 94403
22. Auto Row Smog Test Only
3060 BroadwayOakland, CA 94611
23. 76 Smog Test Only Center
699 Ralston AveBelmont, CA 94002
24. Smog Test Only Center
1150 Old County RdBelmont, CA 94002
25. The Smog Test Only
712 E 12th StOakland, CA 94606
26. Q Smog Check Test Only
5130 International BlvdOakland, CA 94601
27. Super Star Test Only Smog Chck
3315 San Pablo AveEmeryville, CA 94608
28. Star Test Only Smog Check
I never thought I'd leave a review smog shop, but this place is just that good. They are friendly, fast, reasonable, and don't try to upsell repairs…
2027 Alvarado StSan Leandro, CA 94577
From Business: * Test Only Station * We Test All Vehicles While-U-Wait * Free Retest * Test Only Directed Vehicles * Gross Polluters * Regular Smog Check * DMV Renewals * Initial …
30. Oakland Smog Test Only
132 98th AveOakland, CA 94603


text:
I've never had an issue where I had to call customer service so that could be another story...but overall...I'm happy. (in 331 reviews)
LivingSocial reviews
Washington, DC 20005, USA
Tel: +1.8888086676
1,276 Reviews From Our Community
Detailed Rating Summary
Review Highlights
Purchased a Next deal where i paid £15 for £30 to spend at Next. (in 570 reviews)
I got prompt reply for any of my questions from customer service And as far as Credit Card Information. (in 100 reviews)
All Reviews
▼ Sort by: recent
Bought and paid for a mattress topper but I don't know how to redeem the voucher. Ground level no living social have been any help :-(
I bought ink from ink farm.com over a month 1/2 ago.
I have been trying to order ink from them through their website.
To no avail!
I have written them and called them dozens of times. They have done nothing, except there usual nonsense emails that say how awesome of a customer they are.
Do not buy anything from ink farm.com.
I tried calling living social and cannot reach them. When you call and they say press number 4 don't get excited, there is no response.
Hopefully, living social can do a better job about purchased you make.
I usually don't have this problem. We'll see.
Ordered ink cartridges that don't work. Livng Social won't refund their part until I get the merchant to agree to a return. Merchant (Toner Selection in Canada) won't respond to emails or phone calls. Is a rip-off and no help from Livng Social.
Very impressed with all the knowledge; and hard work that Ross and Omar had. They were very polite and got the job done. My carpets look awesome thanks to Ross and Omar.
I have used LivingSocial before and anxiously waited quite a while for delivery. Would probably usevagain if I wanted the item badly enough.
Living Social billed me for an unredeemable deal, and then notified me that they would refund my money within 7-9 days.
Forget livingsocial, stay with Groupon! All deals in livingsocial are impossible to redeem and they are impossible to get in touch with. No e-mail for customer service, no toll-free number, and even after you pay to call them, they "apologize for the inconvenience" and DO NOT get back to you or fix the problem. I wish the Better Business Bureau would take action!
5 friends and I booked a spa weekend with living social and it was exactly as described.
it's good- I wish they had more deals
I purchased 2 separate vouchers for chanterelle cooking school ( 2 vouchers for 2 people each )
So basically for four people ...it turned out to be a scam ....my friend and I paid $ 20 each for the train to get to Manhattan only to find out when we arrived at the " so called school " which was basically a residential apartment building ....apparently other residents of that building complained and they had to Close the school and the police were called....... I was extremely disturbed that living social would back this school that was scamming people and then they refused to give me cash back because ...when I purchased these tickets living social automatically used other deal bucks to pay for this outing they want to give me deal bucks ...but I'm closing the account so the deal bucks will be useless so apparently I'm out $ 140.00 which is a lot of money for me....I contacted Living Social to alert them to this situation one woman laughed the entire time and said she escalated the situation but apparently did nothing....I didn't hear anything for a week so I called back I spoke to three different women the last woman was Katrlyn and she would only return my money in deal bucks or ( phony money ) even though my friend and I were scared to death when we got to this place living social is still refusing to pay me back cash ....and
My friends gave me cash and I need to pay them back but living social will only give me deals bucks so I'm closing my account and would like to go to a news station or a newspaper to help prevent others from getting caught in this situation in the future...right now I'll settle for Yelp
When I want to try something different and knew this is where I go. If I want to try things with a bunch of different people this is where I go. I love the fact that they offer all these different activities and deals and different states. You don't need 100 different apps to do one thing. This is your One-Stop shopping for any state or city you're in.
Great deals on vacations and food.
If you live in a big city, this site is awesome; a must have. You can get two for one deals, eat out with a friend, and end up only paying for yourself, making your friend think you've just bought them dinner haha. I also find out about events going on near me that I otherwise wouldn't have known about. Now I know, and I also have a discount for it!
My first time with Living social! I ordered blue sheets received beige. They say I they can only refund (after I package and return the items)! And they cannot have the vendor ( OpenSky) send the correct color!
Very disappointing experience.
I have bought some wonderful things from LS and some not so great things. LS has refunded my money without a huge hassle. More times often than not I am satisfied with my purchases.
They are the only company I deal with that is so good on returns and customer services. I love them.
Huge discount, service can be better. But still love it.
Another antiquated business that needs you to create yet another marginal internet account instead of using top-level single sign on SSO providers ie. Google
Recently I had bought the jeans paint from famous shop I had got 25% discount on that jeans because I am the existing customer.
I get way too much spam from these guys
I like living social and have used them for several things they seem to have some pretty good deals however last week I found that something that I had bought was going to expire on April 7th I noticed it on the 5th and there was no way that I could use it before the expiration date I tried to find out how I could get a refund for the item before it expired it was impossible to figure it out and there is no phone number to be able to call them. I figure I have just lost my money now because I can't figure out how to get ahold of them to refund the item it is now past the 7th which is the day that it expired and I still am sitting here trying to figure out how to contact them to cancel this item they need a little bit better contact system for their customers.
have used for items and local events that I normally would have never done!!! Excellent experience
I purchased 4 tix for use at my local movie theater. Useless to try and redeem. When I tried to ask for refund or voucher it was no go. Compared to other like sites, this was appears more as a pyramid scam than anything else
36 Questions & Answers
SiteJabber Tip
LivingSocial Corporate Headquarters
Related Articles and Tips
Have you ever wondered how daily deals sites worked? Hailed as a great success this new, niche retail market is helping people...
Why wouldn't you want to stretch your buck while shopping for your favorite brands online? Shopping on a traditional...
Long gone are the days when travel required sitting down with your local travel agent months before your trip. Today, simply...
More Daily Deals Businesses
About LivingSocial (from the business)
Daily Deals Sites – Reviewed By Consumers


text:
|By PR Newswire
Article Rating:
|January 16, 2014 02:34 PM EST
SCHENECTADY, N.Y., Jan. 16, 2014 /PRNewswire/ -- SI Group, Inc., a leading global developer and manufacturer of chemical intermediates, specialty resins, and solutions, announced its victory in a landmark intellectual property lawsuit before the International Trade Commission (ITC).
(Logo: http://photos.prnewswire.com/prnh/20130204/NY53537LOGO-b )
SI Group had filed a complaint with the ITC alleging that Sino Legend and the other respondents had misappropriated SI Group trade secrets by importing certain tackifier resins into the U.S. The Sino Legend products at issue in the case included SL-1801, SL-1801 LFP, SL-1802, and SL-1802 LFP tackifier resins. In a final determination issued January 15, 2014, the ITC confirmed that Sino Legend, Red Avenue and certain affiliates of those companies violated Section 337 of the U.S. Tariff Act by importing rubber resins made using SI Group trade secrets. As a result, the ITC has imposed a 10-year ban on the importation of the affected products into the U.S. The import ban goes into immediate effect.
"It's a major victory for SI Group," said Frank Bozich, President and CEO. "The ITC's final decision reinforces what we've been saying all along: Our intellectual property was stolen. The 10-year exclusion order helps to right that wrong."
The ITC complaint, filed on May 21, 2012, came as a result of Sino Legend colluding with, and then hiring away, a plant manager from SI Group's Shanghai manufacturing plant. Since that time, Sino Legend has been producing rubber resins in competition with SI Group's proprietary rubber resins.
The public version of Judge Rogers' previously released initial determination is available on SI Group's website (http://www.siigroup.com/press). The ITC's final determination will be posted as soon as it becomes available. Additional information on this case, No. 337-TA-849, is available on the ITC's website.
About SI Group
SI Group is a family-owned company founded in 1906 and headquartered in Schenectady, New York. A leading global developer and manufacturer of phenolic resins, alkylphenolic resins, alkylated phenols and other chemical intermediates, SI Group operates 20 facilities in 10 countries around the world. For more information about SI Group, visit www.siigroup.com.
Brooke Manrique
Public Relations & Marketing Communications Manager
SI Group, Inc.
[email protected]
SOURCE SI Group, Inc.
The Internet of Things will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform. In his session at @ThingsExpo, Craig Sproule, CEO of Metavine, demonstrated how to move beyond today's coding paradigm and shared the must-have mindsets for removing complexity from the develo...
Jul. 30, 2016 03:00 AM EDT Reads: 1,638
SYS-CON Events announced today that MangoApps will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. MangoApps provides modern company intranets and team collaboration software, allowing workers to stay connected and productive from anywhere in the world and from any device.
Jul. 30, 2016 02:45 AM EDT Reads: 1,486
The IETF draft standard for M2M certificates is a security solution specifically designed for the demanding needs of IoT/M2M applications. In his session at @ThingsExpo, Brian Romansky, VP of Strategic Technology at TrustPoint Innovation, explained how M2M certificates can efficiently enable confidentiality, integrity, and authenticity on highly constrained devices.
Jul. 30, 2016 02:15 AM EDT Reads: 1,184
"delaPlex Software provides software outsourcing services. We have a hybrid model where we have onshore developers and project managers that we can place anywhere in the U.S. or in Europe," explained Manish Sachdeva, CEO at delaPlex Software, in this SYS-CON.tv interview at @ThingsExpo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Jul. 30, 2016 02:00 AM EDT Reads: 1,685
Keeping pace with advancements in software delivery processes and tooling is taxing even for the most proficient organizations. Point tools, platforms, open source and the increasing adoption of private and public cloud services requires strong engineering rigor – all in the face of developer demands to use the tools of choice. As Agile has settled in as a mainstream practice, now DevOps has emerged as the next wave to improve software delivery speed and output. To make DevOps work, organization...
Jul. 30, 2016 12:30 AM EDT Reads: 2,337
Predictive analytics tools monitor, report, and troubleshoot in order to make proactive decisions about the health, performance, and utilization of storage. Most enterprises combine cloud and on-premise storage, resulting in blended environments of physical, virtual, cloud, and other platforms, which justifies more sophisticated storage analytics. In his session at 18th Cloud Expo, Peter McCallum, Vice President of Datacenter Solutions at FalconStor, discussed using predictive analytics to mon...
Jul. 30, 2016 12:30 AM EDT Reads: 2,130
The IoT is changing the way enterprises conduct business. In his session at @ThingsExpo, Eric Hoffman, Vice President at EastBanc Technologies, discussed how businesses can gain an edge over competitors by empowering consumers to take control through IoT. He cited examples such as a Washington, D.C.-based sports club that leveraged IoT and the cloud to develop a comprehensive booking system. He also highlighted how IoT can revitalize and restore outdated business models, making them profitable ...
Jul. 29, 2016 10:15 PM EDT Reads: 2,076
SYS-CON Events announced today that Isomorphic Software will exhibit at DevOps Summit at 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Isomorphic Software provides the SmartClient HTML5/AJAX platform, the most advanced technology for building rich, cutting-edge enterprise web applications for desktop and mobile. SmartClient combines the productivity and performance of traditional desktop software with the simp...
Jul. 29, 2016 10:00 PM EDT Reads: 1,289
"When you think about the data center today, there's constant evolution, The evolution of the data center and the needs of the consumer of technology change, and they change constantly," stated Matt Kalmenson, VP of Sales, Service and Cloud Providers at Veeam Software, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Jul. 29, 2016 09:45 PM EDT Reads: 1,500
Internet of @ThingsExpo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with the 19th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world and ThingsExpo Silicon Valley Call for Papers is now open.
Jul. 29, 2016 08:00 PM EDT Reads: 2,749
We all know the latest numbers: Gartner, Inc. forecasts that 6.4 billion connected things will be in use worldwide in 2016, up 30 percent from last year, and will reach 20.8 billion by 2020. We're rapidly approaching a data production of 40 zettabytes a day – more than we can every physically store, and exabytes and yottabytes are just around the corner. For many that's a good sign, as data has been proven to equal money – IF it's ingested, integrated, and analyzed fast enough. Without real-ti...
Jul. 29, 2016 07:45 PM EDT Reads: 1,186
Actian Corporation has announced the latest version of the Actian Vector in Hadoop (VectorH) database, generally available at the end of July. VectorH is based on the same query engine that powers Actian Vector, which recently doubled the TPC-H benchmark record for non-clustered systems at the 3000GB scale factor (see tpc.org/3323). The ability to easily ingest information from different data sources and rapidly develop queries to make better business decisions is becoming increasingly importan...
Jul. 29, 2016 06:15 PM EDT Reads: 962
SYS-CON Events announced today that 910Telecom will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Housed in the classic Denver Gas & Electric Building, 910 15th St., 910Telecom is a carrier-neutral telecom hotel located in the heart of Denver. Adjacent to CenturyLink, AT&T, and Denver Main, 910Telecom offers connectivity to all major carriers, Internet service providers, Internet backbones and ...
Jul. 29, 2016 06:00 PM EDT Reads: 937
Big Data, cloud, analytics, contextual information, wearable tech, sensors, mobility, and WebRTC: together, these advances have created a perfect storm of technologies that are disrupting and transforming classic communications models and ecosystems. In his session at @ThingsExpo, Erik Perotti, Senior Manager of New Ventures on Plantronics' Innovation team, provided an overview of this technological shift, including associated business and consumer communications impacts, and opportunities it ...
Jul. 29, 2016 05:15 PM EDT Reads: 400
Cloud analytics is dramatically altering business intelligence. Some businesses will capitalize on these promising new technologies and gain key insights that'll help them gain competitive advantage. And others won't. Whether you're a business leader, an IT manager, or an analyst, we want to help you and the people you need to influence with a free copy of "Cloud Analytics for Dummies," the essential guide to this explosive new space for business intelligence.
Jul. 29, 2016 05:15 PM EDT Reads: 988


text:
Join Date: Nov 2001
Location: in my skin
Posts: 3,932
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
|Thread Tools
Originally Posted by ladylee
Throwing out a topic to see if anyone wants to talk about it-what emotions come up when you hear other women judging those who have had cesareans?
Originally Posted by amanda721
the problem i was having and still am I feel robbed. I know what it is like to have a natural cb. A c-section was unreal.
|All I heard was women give birth to breech babies all the time, how do you think they did it before c-sections.
Originally Posted by whimsy
There are a lot of things women used to do that I'm glad we don't have to do now.
They made childbirth safer for us. We in turn, can make childbirth better for our daughters. (By having these discussions and taking the best from the past and the best of modern science)
Originally Posted by tuffykenwell
But according to all of the research I have read cesearean delivery of breech babies doesn't actually improve outcomes when compared to vaginal breech with an experienced practitioner (although I think that may not be true of transverse and footling breeches which I think are the most dangerous to try to deliver vaginally).
|Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
|Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Online Users: 13,406
|55 members and 13,351 guests
|AMG , averysmomma05 , b00angelz , carlye828 , cdnstepmum , Deborah , Dovenoir , emmy526 , girlspn , happy-mama , hillymum , ian'smommaya , ibahippiemama , Iron Princess , japonica , JElaineB , joycef , katelove , keepingFAITH , lemon_verbena , lilmissgiggles , lisak1234 , mamabear0314 , Mamalari , marsupial-mom , MeepyCat , Michele123 , Mirzam , moominmamma , Mylie , MylittleTiger , NaturallyKait , Nenya , newmamalizzy , oaksie68 , redsally , rocky , RollerCoasterMama , RosemaryV , rubelin , shanna-cat , shantimama , siennaflower , SimplyMama , Skippy918 , sns6848 , Springshowers , sren , Xerxella , zebra15
|Most users ever online was 449,755, 06-25-2014 at 12:21 PM.


text:
Foursquare © 2016 Lovingly made in NYC & SF
People tend to check in during these times:
Grocery Store
9424 S Pulaski Rd
"Deli on Sunday afternoon is SO slow!"
3231 W 87th St (at S Kedzie Ave)
9200 S Western Ave
"Low prices, brand names, courteous Service. Fresh Fruit and vegetables. Fresh meats large variety. They even have house hold items. Handicap assessable Vehicles. Fantastic Experience."
Department Store
4120 W 95th St (btwn Pulaski & Keeler)
"10% is excluded on electronics"
Walmart Supercenter
Big Box Store
2500 W 95th St
"Banana pudding $2.50 a lbs"
Hot Dogs · $$
4020 W 95th St (at Pulaski Rd)
"Good hot dogs but great burgers too! Try the double bacon cheeseburger, it has a great grilled flavor"
my chitown faves
Created by Leesha Anne19 items • 1 follower
Make sure your information is up to date. Plus use our free tools to find new customers.
Download Foursquare for your smart phone and start exploring the world around you!


text:
It only takes a minute to get started. Fill out our uncomplicated sign up form and login to the website.
This step is noncompulsory but will dramatically raise your chances of your profile getting read by other members. Introduce yourself, your pasttimes and upload some good photos of yourself.
Utilise our website's advanced search to uncover members who meet your criteria. Or just scan through listings and uncover daters that you find interesting.
Discovered someone who you're attracted to? Send a message to them or just a wink and see if anything develops. With a little luck you'll be on your way to true love.
It'll only take a few minutes


text:
Say this for Toronto Blue Jays shortstop Jose Reyes: He certainly didn't waste any time getting injured this season. The speedy but brittle fourth-round selection in ESPN live drafts left Monday's game with what was called hamstring tightness after only one at-bat and before the evening was over he already had been placed on the 15-day disabled list. It's hardly shocking news that Reyes is hurt again, but really, after one at-bat? Couldn't he have at least waited until the weekend?
Is it finally time to believe in Joey Gallo for fantasy?
7hEric Karabell
Prospects to stash ahead of the MLB trade deadline
1dEric Karabell
Fantasy winners and losers of the Aroldis Chapman trade
2dEric Karabell
Does Pomeranz trade help or hurt his fantasy value?
13dEric Karabell
All-Star pitcher report: Sanchez, Pomeranz, Wright break out
14dEric Karabell
Will Giancarlo Stanton total 40 homers in 2016?
15dEric Karabell
Right-handers Reyes, Musgrove shine in Futures Game
16dEric Karabell
Middle infielders Bregman, Moncada thrive in Futures Game
16dEric Karabell
Free agent buying guide: Top under-owned players
19dEric Karabell
Closer stock watch: Britton on rise while Kimbrel struggles
20dEric Karabell
Biggest fantasy All-Star snubs at each position
21dEric Karabell
Latest fantasy baseball prospects to add and drop
22dEric Karabell
Free-agent buying guide: Replacing Kershaw, available steals
25dEric Karabell


text:
Adobe LiveCycle Jobs
Jobs 1 to 3 of 3
T-SQL Support Developer - Manchester £25-35K.
Our client based in Manchester is currently looking for a skilled Support Developer with strong T-SQL experience... From a support perspective adheres to service management principles and seeks guidance when required; ensures standards and procedures are adhered to and documentation maintained... Essential Criteria: T-SQL (Stored Procedures, Data Edits)...
Manchester, Lancashire -
Adria Solutions Ltd
Salary: £25000 - £35000 per annum + BenefitsPosted: 1 hour ago
Correspondence Developer
We specialise in Financial Services delivering innovative software using agile principles in an evolving DevOps culture. Our vision is to provide our customers a market leading digital experience and become a leading FinTech organisation... - Collaborate with colleagues on unique challenges at scale - Leverage the latest technologies to deliver across a...
Manchester, Lancashire -
Think Money Group
Salary: CompetitivePosted: 8 days ago
T-SQL Support Developer, Manchester, Greater Manchester, Lancashire
T-SQL Support Developer required in Manchester for a leading Financial Services company. The Role: You will be responsible for analysing, developing and supporting the production of various forms of correspondence across the business. Essential Skills: T-SQL - Stored Procedures, Data Edits. Desirable Skills: XML Schema, Adobe LiveCycle Designer, Workbench...
Manchester, Lancashire -
Candour Solutions
Salary: Excellent + BenefitsPosted: 6 days ago


text:
Latest Florida Poll: Obama 50%, Romney 46%
Florida is once again shaping up to be the biggest battleground of the 2012 election, and many election prognosticators have pointed out it's would be nearly impossible for President Barack Obama to win Florida and still lose the general election. Though a poll in May showed Mitt Romney with a six point lead in the Sunshine State, two polls taken since then, including one released today, show Obama with a four-point lead.
That Quinnipiac poll released about three week ago, showed Romney in command, 47 to 41 percent. Just a day later, though, NBC News released a poll taken by Marist that showed him with a 48-to-44 point lead.
The latest poll by Public Policy Polling seems to echo that NBC poll. Obama now leads 50-46. That's a slight change from PPP's poll in mid-April that showed Obama leading 50-45.
According to the poll, Obama maintains leads among women (61-36), Hispanics (61-36), and voters under 30 (65-27). Romney has double digit leads among white and senior voters.
Upcoming Events
Monster Jam
TicketsSat., Aug. 13, 2:00pm
Miami Dolphins
TicketsThu., Aug. 25, 8:00pm
Miami Dolphins vs. Atlanta Falcons
TicketsThu., Aug. 25, 8:00pm
Lucha Loco Live!
TicketsSat., Aug. 27, 7:00pm
The poll also shows that Marco Rubio would not be a big help among Latinos if he was selected as Romney's running mate. Hispanics would only favor the a GOP ticket with Rubio 55-40, and his presence wouldn't be enough to tip the results toward Romney. (Rubio is also notably polarizing: 44 percent of Floridians view him favorably, while 40 percent view him unfavorably. Those aren't Rick Scott numbers, but they're also not the healthiest.)
Follow Miami New Times on Facebook and Twitter @MiamiNewTimes.
Get the This Week's Top Stories Newsletter
Every week we collect the latest news, music and arts stories — along with film and food reviews and the best things to do this week — so that you'll never miss Miami New Times' biggest stories.
In Case You Missed It
Upcoming Events
Nova Southeastern University Sharks Volleyball
TicketsFri., Jul. 29, 1:00pm
Florida Launch vs. Rochester Rattlers
TicketsSat., Jul. 30, 7:30pm
Florida Launch
Sat., Jul. 30, 7:30pm
Fight Time PRO MMA
TicketsFri., Aug. 12, 8:00pm
Popular Stories
Sponsor Content


text:
Honda to preview new hybrid in Paris
Honda's plans to regroup its hybrid efforts are well documented. In addition to a new Civic hybrid, the automaker revealed that a production hybrid based on the sharp CR-Z concept is also in the works. We also know that a third hybrid model is being developed from the ground up, and we'll get to see it this September at the 2008 Paris Motor Show. This third hybrid will be smaller than the Civic Hybrid and Toyota Prius, the benchmark for hybrids the world over, and use a new version of Honda's "mild hybrid" Integrated Motor Assist system that can aid the car's gas engine in acceleration but not power the car on its own. In addition to great fuel economy, Honda is also targeting lower carbon-dioxide emissions than gas- or diesel-powered competitors. As has been noted before, Honda is betting that selling hybrids at a lower cost will create the demand it never saw for the relatively expensive Civic Hybrid. Its new hybrid will have an estimated base price of €16,000 to €20,000 (the Prius starts at €24,000 in Europe, the Civic Hybrid at €23,800). Production plans call for 200,000 units to be produced annually, with half earmarked for North America.
[Source: Automotive News, sub. req'd]
- Volvo shoots for self-drivers by 2021
- Jeep spends $1 billion on factories
- Find Parts & Accessories for your vehicle!
- Obama rolls out new EV plan
- Infiniti dealers ranked best, Tesla worst
- Compare Volvo XC90 and Lincoln MKX
From Our Partners
Consumer Resources
Recharge Wrap-up: Autopilot mitigates accident in video, Ford exits India's EV consortiumWatch Video


text:
It used to be full of stars, but now I'm full of scars.
Somewhere near th I got lost in:
Moroccan LITHP the Revere Ti table þ Far Beyond the Stars Parade rest CH text message typos Lambið American spelling trash Parental Advisory: Explicit Lyrics The Mission Bard PA Breathing marks in Greek AC Thorium Zippy the Pinhead DPT How to pronounce a French "R" Thailand is not pronounced Thighland Elision .th INS HTML tags Non sequitur dialect EIPT Welsh Alphabet Enjoy yourself. This is utmost in importance. Wheatfield with crows How to pronounce an English "R" ð TG The Going Of The Battery


text:
|By PR Newswire
Article Rating:
|August 7, 2014 02:00 PM EDT
ATLANTA, Aug. 7, 2014 /PRNewswire/ -- Novelis, the world leader in aluminum rolling and recycling, today announced price increases on its North American Automotive and Specialty aluminum sheet products for all new orders effective immediately. All existing orders and firm agreements confirmed prior to August 7, 2014 will be honored throughout the contract period.
Automotive Products
6xxx series automotive alloys
5xxx series automotive alloys
Specialty Products
1xxx and 3xxx series alloys
5xxx series
The Automotive price increase is in addition to the previously announced pricing adjustment made on January 1, 2014 of $0.11 per pound for 6000-series, 5182-series and 5000-series coated Automotive alloys.
"To support the rapidly growing automotive market demand, Novelis remains committed as the industry leader in announced capacity investments in North America, Europe and Asia," said Marco Palmieri, Senior Vice President, Novelis and President, Novelis North America. "In North America, we've commissioned two new auto finishing lines in Oswego, New York that are in full production and are completing construction of a third auto finishing line increasing our regional capacity by up to 360,000 tons per year. That's seven times our current production capacity and an important milestone to remain the industry leader as North American automotive market demand is expected to increase twenty-fold in the next 10 years."
In addition to the Oswego expansion, the automotive finishing line in Changzhou, China, is on track to be in production in the next 90 days and will have a capacity of 120,000 tons. The company has also broken ground on a new automotive finishing line in Nachterstedt, Germany. When all of the new lines are commissioned by late 2015, Novelis' global automotive sheet capacity will reach about 900,000 tons per year, a three-fold increase from just a year ago.
Novelis is the world's leading provider of aluminum automotive sheet, used for making structural components and exterior body panels. Novelis aluminum can be found in more than 180 different vehicle models produced by leading automakers around the globe.
About Novelis
Novelis Inc. is the global leader in aluminum rolled products and the world's largest recycler of aluminum. The company operates in nine countries, has approximately 11,200 employees and reported revenue of approximately $10 billion for its 2014 fiscal year. Novelis supplies premium aluminum sheet and foil products to transportation, packaging, construction, industrial and consumer electronics markets throughout North America, Europe, Asia and South America. The company is part of the Aditya Birla Group, a multinational conglomerate based in Mumbai, India. For more information, visit novelis.com and follow us at facebook.com/NovelisInc and twitter.com/Novelis.
SOURCE Novelis Inc.
Actian Corporation has announced the latest version of the Actian Vector in Hadoop (VectorH) database, generally available at the end of July. VectorH is based on the same query engine that powers Actian Vector, which recently doubled the TPC-H benchmark record for non-clustered systems at the 3000GB scale factor (see tpc.org/3323). The ability to easily ingest information from different data sources and rapidly develop queries to make better business decisions is becoming increasingly importan...
Jul. 29, 2016 06:15 PM EDT Reads: 946
SYS-CON Events announced today that 910Telecom will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Housed in the classic Denver Gas & Electric Building, 910 15th St., 910Telecom is a carrier-neutral telecom hotel located in the heart of Denver. Adjacent to CenturyLink, AT&T, and Denver Main, 910Telecom offers connectivity to all major carriers, Internet service providers, Internet backbones and ...
Jul. 29, 2016 06:00 PM EDT Reads: 910
Big Data, cloud, analytics, contextual information, wearable tech, sensors, mobility, and WebRTC: together, these advances have created a perfect storm of technologies that are disrupting and transforming classic communications models and ecosystems. In his session at @ThingsExpo, Erik Perotti, Senior Manager of New Ventures on Plantronics' Innovation team, provided an overview of this technological shift, including associated business and consumer communications impacts, and opportunities it ...
Jul. 29, 2016 05:15 PM EDT Reads: 366
Cloud analytics is dramatically altering business intelligence. Some businesses will capitalize on these promising new technologies and gain key insights that'll help them gain competitive advantage. And others won't. Whether you're a business leader, an IT manager, or an analyst, we want to help you and the people you need to influence with a free copy of "Cloud Analytics for Dummies," the essential guide to this explosive new space for business intelligence.
Jul. 29, 2016 05:15 PM EDT Reads: 974
You think you know what's in your data. But do you? Most organizations are now aware of the business intelligence represented by their data. Data science stands to take this to a level you never thought of – literally. The techniques of data science, when used with the capabilities of Big Data technologies, can make connections you had not yet imagined, helping you discover new insights and ask new questions of your data. In his session at @ThingsExpo, Sarbjit Sarkaria, data science team lead ...
Jul. 29, 2016 04:45 PM EDT Reads: 1,239
WebRTC is bringing significant change to the communications landscape that will bridge the worlds of web and telephony, making the Internet the new standard for communications. Cloud9 took the road less traveled and used WebRTC to create a downloadable enterprise-grade communications platform that is changing the communication dynamic in the financial sector. In his session at @ThingsExpo, Leo Papadopoulos, CTO of Cloud9, discussed the importance of WebRTC and how it enables companies to focus...
Jul. 29, 2016 04:15 PM EDT Reads: 1,078
Qosmos has announced new milestones in the detection of encrypted traffic and in protocol signature coverage. Qosmos latest software can accurately classify traffic encrypted with SSL/TLS (e.g., Google, Facebook, WhatsApp), P2P traffic (e.g., BitTorrent, MuTorrent, Vuze), and Skype, while preserving the privacy of communication content. These new classification techniques mean that traffic optimization, policy enforcement, and user experience are largely unaffected by encryption. In respect wit...
Jul. 29, 2016 04:15 PM EDT Reads: 419
ReadyTalk has expanded the capabilities of the FoxDen collaboration platform announced late last year to include FoxDen Connect, an in-room video collaboration experience that launches with a single touch. With FoxDen Connect, users can now not only engage in HD video conferencing between iOS and Android mobile devices or Chrome browsers, but also set up in-person meeting rooms for video interactions. A host's mobile device automatically recognizes the presence of a meeting room via beacon tech...
Jul. 29, 2016 04:15 PM EDT Reads: 384
Manufacturers are embracing the Industrial Internet the same way consumers are leveraging Fitbits – to improve overall health and wellness. Both can provide consistent measurement, visibility, and suggest performance improvements customized to help reach goals. Fitbit users can view real-time data and make adjustments to increase their activity. In his session at @ThingsExpo, Mark Bernardo Professional Services Leader, Americas, at GE Digital, discussed how leveraging the Industrial Internet a...
Jul. 29, 2016 03:15 PM EDT Reads: 650
On Dice.com, the number of job postings asking for skill in Amazon Web Services increased 76 percent between June 2015 and June 2016. Salesforce.com saw its own skill mentions increase 37 percent, while DevOps and Cloud rose 35 percent and 28 percent, respectively. Even as they expand their presence in the cloud, companies are also looking for tech professionals who can manage projects, crunch data, and figure out how to make systems run more autonomously. Mentions of 'data science' as a skill ...
Jul. 29, 2016 03:00 PM EDT Reads: 441
In his session at Cloud Expo, Robert Cohen, an economist and senior fellow at the Economic Strategy Institute, will provide economic scenarios that describe how the rapid adoption of software-defined everything including cloud services, SDDC and open networking will change GDP, industry growth, productivity and jobs. This session will also include a drill down for several industries such as finance, social media, cloud service providers and pharmaceuticals.
Jul. 29, 2016 02:15 PM EDT Reads: 376
IoT generates lots of temporal data. But how do you unlock its value? You need to discover patterns that are repeatable in vast quantities of data, understand their meaning, and implement scalable monitoring across multiple data streams in order to monetize the discoveries and insights. Motif discovery and deep learning platforms are emerging to visualize sensor data, to search for patterns and to build application that can monitor real time streams efficiently. In his session at @ThingsExpo, ...
Jul. 29, 2016 02:00 PM EDT Reads: 1,203
Ixia (Nasdaq: XXIA) has announced that NoviFlow Inc.has deployed IxNetwork® to validate the company's designs and accelerate the delivery of its proven, reliable products. Based in Montréal, NoviFlow Inc. supports network carriers, hyperscale data center operators, and enterprises seeking greater network control and flexibility, network scalability, and the capacity to handle extremely large numbers of flows, while maintaining maximum network performance. To meet these requirements, NoviFlow in...
Jul. 29, 2016 01:00 PM EDT Reads: 767
Choosing the right cloud for your workloads is a balancing act that can cost your organization time, money and aggravation - unless you get it right the first time. Economics, speed, performance, accessibility, administrative needs and security all play a vital role in dictating your approach to the cloud. Without knowing the right questions to ask, you could wind up paying for capacity you'll never need or underestimating the resources required to run your applications.
Jul. 29, 2016 01:00 PM EDT Reads: 727
Security, data privacy, reliability and regulatory compliance are critical factors when evaluating whether to move business applications from in-house client hosted environments to a cloud platform. In her session at 18th Cloud Expo, Vandana Viswanathan, Associate Director at Cognizant, In this session, will provide an orientation to the five stages required to implement a cloud hosted solution validation strategy.
Jul. 29, 2016 01:00 PM EDT Reads: 1,195


text:
Roc Nation producer and artist Jahlil Beats is back with the third installment in his Legend Era mixtape series. Stream or download the project below which features some already released tracks he produced for others, some exclusive and a few remixes.
Initialize ads
Download Mixtape | Free Mixtapes Powered by DatPiff.com


text:
Discover a selection of top forums lost vampire on the internet. Come to share your passion on forums lost vampire and meet other fans of lost vampire. Then, why don't you create your own forum of lost vampire ?
Vampire, Werewolf, Witch, Wizard, Angel, Demon, Fey, and Nekomini. You chose your own path. Become a Supernatural being that rules all.
turning, supernatural, #vampire, werewolf, witch, wizard, angel, demon, nekomini, chose, path, rules
Dragons Roleplaying Forum is an active and reliable RPG about dragons. We hunt and fly, exploring lost lands and seas. We fly, with freedom, with grace, with POWER.
dragons, roleplaying, forum, hunt, tribes, exploring, traversing, lands!
Avalon is an Old World Of Darkness Vampire: The Masquerade Play by Post Role Playing experience of gothic horror set in the fictional city of Avalon.
#vampire, avalon, after, dark, world, darkness, masquerade, play, post, role, playing, experience, gothic, horror, fictional, city
Free forum : a place to talk about your favorite shows, movies and current events
forum, walking, dead, game, thones, true, blood, #lost, breaking, show, reviews, discussion, current, affairs, community, american, horror, story
The Sabbat have overrun Dallas for too long. The inner circle has chosen you to take backt he city. After you have fought for your right to survive, how will you continue to grow the city?
delirium, #vampire, masquerade, larp, sabbat, have, overrun, dallas, long, inner, circle, chosen, take, backt, city, after, fought, your, right, survive, will, continue, grow
Free forum : TV Show discussion Current and Older shows. Also movies
free, forum, talk, show, arrow, person, interest, shield, castle, walking, dead, summer, glau, game, thrones, breaking, dexter, hell, wheels, survivor, #vampire, diaries, vikings, bates, motel, continuum
An Old World of Darkness Montana-based vampire game of politics, intrigue, gold, sapphires and werewolves lurking around the corner.
gold, rush, world, darkness, montana-based, #vampire, game, politics, intrigue, sapphires, werewolves, lurking, corner
A tropical wolf pack that resides on a long lost island.
oahu, isles, pack, tropical, wolf, resides, long, #lost, island
The vampire RPG that is shaking the darkness to it's core. . .
free, forum, midnight, reflections, #vampire, that, shaking, darkness, it's, core
love never lost, found
A hybrid first and second edition PbP game of Changeling the Lost set in Las Vegas. I'm bad at descriptions and this is a private game anyway so that's all you get.
viva, #lost, vegas, hybrid, edition, game, changeling, i'm, descriptions, private, that's


text:
|New Business Manager/Director - Enterprise Sales
|Location: London
|Salary: £100,001+
|IT Analyst Programmer - Support Centre
|Location: Birmingham
|Salary: £30,000 - 35,000
|Senior Java Developer
|Location: London
|Salary: £Negotiable
|Pega Specialist
|Location: London
|Salary: £Negotiable
|View all vacancies
> Upload your CV and let recruiters find you
> Receive personalised Jobs-by-Email alerts
Find the answers to your questions online.
Use our Intelligent Search
Technology (IST)
Location: Glasgow, Lanarkshire, Home Based Salary: Up to £90,000 + Bens.
Location: Basildon, Essex Salary: Up to £50,000 + Bens


text:
Do not violate our rightsJanuary 28,2013Do not violate our rights
Dear Congressman Welch, and Senators Leahy and Sanders,
In questions of power, then, let no more be heard of confidence in man, but bind him down from mischief by the chains of the Constitution. Thomas Jefferson
Chained down by the Constitution. How about that. The right to KEEP and BEAR arms shall not be infringed. Just why did they include that amendment? The Constitution and Bill of Rights were written for the individual an individual who might need protecting from government tyranny. They knew all about it, and were planning ahead. With the Second Amendment, the rest would remain safe.
Its significant that they didnt say how you would keep, or what you would keep. Having gone through what they went through in determining the need for these documents, you can bet they meant you would be able to keep and bear the type of arms that your government keeps.
Sorry but you are bound by the Constitution. The inconvenient truth is, no matter what trouble comes my way be it a foot soldier from a hostile foreign country, a 225-pound thug high on drugs who has just smashed the glass out of my front door and is reaching in to unlock it, or Heaven forbid, my own government gone mad with power I am an equal adversary and thanks to the Constitution and my Bill of Rights, I will stay that way.
We are law-abiding citizens, only your potential disregard of the Constitution will make criminals out of Americans like us. I remember the American patriot who proudly spoke for all who love freedom when he declared you can have this one only when you take it ... from my cold, dead hands.
Gentleman, I would suggest that the next move is yours, but being bound by the Constitution, I would sooner expect to see you step down than to violate our liberty.
IraMORE IN LettersVermont has made great strides to add renewable resources to its power generation portfolio, to... Full StoryI have had the opportunity to meet and listen to the Democratic candidates for governor on a... Full StoryAs a financial official, I could list many reasons for choosing Bruce Lisman for Vermont governor... Full Story
- Most Popular
- Most Emailed


text:
Free Shipping & Returns on all glasses orders | Every pair includes Standard Air Lenses
Kam Dhillon 3077 Sophia Bare
Derek Cardigan 7001 Black
Derek Cardigan 7009 Black
7 For All Mankind 774 Matte Aqua
Kam Dhillon 3080 Luisa White
Joseph Marc Burrowes 4148 Green
Kam Dhillon 3084 Eva Blue
Kam Dhillon 3074 Mina Bare
Joseph Marc Morgan 4146 Honey
Joseph Marc Burrowes 4148 Honey
Joseph Marc Becket 4149 Honey
Joseph Marc Kent 4150 Honey
Derek Cardigan 7001 Brown Tortoiseshell
Savvy 1008 Purple
Joseph Marc 4096 Havana
Joseph Marc 4116 Black
Love L748 Purple Pink
Love L750 Brown Tort
Perspective 2018 Black
Carmen Marc Valvo Pauletta Slate
Y-Sport By Dakota Smith Truth Steel
Laura Ashley Girls Darling Pink
Laura Ashley Girls Flower Bliss Brown Sugar
Koali KO6723K MM 152 Medium Brown
This offer is valid for new subscribers only. To stop receiving emails from Clearly at any point in time, please select the unsubscribe option located in all emails. For more information, please see our privacy policy and terms and conditions, or contact us.
We promise to never share your information.
Privacy Policy


text:
Hatteras Financial News
News on Hatteras Financial (Ticker: HTS) continually updated from thousands of sources around the net.
Hatteras Financial news is powered by NewsRank™
Trending Now
Then and Now: 39 Rock Gods Who Used to Be Smoking Hot
Then and Now: How Did Your Favorite 1990s Stars Hold Up?
25 Shocking Photos Of What Your Favorite PLAYBOY Playmates Look Like NOW
37 Awesome Hollywood Couples Who Paved The Way For LGBT People Everywhere
The 30 Most Extreme Body Transformations For A Movie Role
Updated: Tue Jul 26, 2016 01:51 pm
Copyright © 2016 Topix LLC