Viewing 15 posts - 5,971 through 5,985 (of 5,987 total)
If someone is developing something like a desktop application for release as shareware, and they feel it's important to protect the contents of proprietary reference tables and SQL queries, then...
May 4, 2010 at 12:38 pm
I don't think the option is available in the SSMS table designer, but look up CREATE TABLE in SQL Server Books Online, and see the option { TEXTIMAGE_ON { filegroup...
May 4, 2010 at 12:25 pm
If the instance of SQL Server is running on the user's desktop, then by default, they are a privillaged user. Even if you embedded and encrypted the SQL statements inside...
May 4, 2010 at 12:14 pm
I understand that you have hundreds of tables, and you want to "form relationships" between them. Could you describe in more detail what the objective is?
I'm thinking that this is...
May 4, 2010 at 11:46 am
-- Here is the setup:
declare @sample table (RecID int, RecType int, Hierarchy int, Msg char(1));
insert into @sample Values (1, 5555, 10, null );
insert into @sample Values (2, 5555, 20, null...
April 30, 2010 at 2:07 pm
If you get them all to line up nose to rear, then you're lucky. It's been said that managing IT developers is like trying to herd cats.
April 30, 2010 at 1:29 pm
-- create and insert a table variable containing missing numbers.
declare @missingnumbers table (n int not null primary key);
insert into @missingnumbers
select 1 union select 2 union select 4 union select 5...
April 30, 2010 at 8:33 am
Would simply adding this additional condition give you what you need?
.. and right(origin_tracer_no,2) <> 'No'
April 30, 2010 at 8:00 am
Management in the IT industry is different from other industries. If you look at the resume of IT managers, you'll see that most of them actually do not have a...
April 30, 2010 at 7:00 am
A clustered index on column(s) containing non-sequential data is one explanation for extremely poor performing inserts and updates. With a clustered table, SQL Server clusters the data pages (basically like,...
April 29, 2010 at 3:40 pm
I've never liked the idea of creating foreign key constraints with the cascade UPDATE/DELETE option. Let's assume that a misguided developer is trying to insert/update data in the INV_STATUS dimension...
April 29, 2010 at 8:03 am
The technical puzzle proposed in this discussion is interesting, but it has obviously run it's course. I'm interested about why you would need to know the "last" value inserted into...
April 29, 2010 at 7:31 am
Here is a well illustrated primer on SQL joins by Pinal Dave, one of the best SQL Server bloggers.
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
The specific situation you present here, which is parsing...
April 28, 2010 at 7:45 am
Yes, you can index a partitioned view. There are some requirements, like all tables must be in the same database and there must be a unique clustered index, which you...
April 27, 2010 at 12:04 pm
You are always going to have locks of one type or another. I guess the real problem you're wanting to describe is that you're encountering blocks on your DML statements....
April 27, 2010 at 8:58 am
Viewing 15 posts - 5,971 through 5,985 (of 5,987 total)