|
|
|
Constraint using UDF always violates
Mon, 22 Sep 2008 22:43:01 -0700
I'm trying to write a check constraint that uses a UDF to validate whenever
an INSERT or UPDATE occures. I can write the UDF and configure the
constraint, however when I do an insert I always get an "INSERT statement
conflicted with the CHECK constraint" error, even though if I call the UDF
directly I get t ...
|
Auditss in SQL server 2008
Mon, 22 Sep 2008 20:02:01 -0700
I am new to SQL server 2008. A standard edition of SQL server 2008 has been
installed on windows server 2003.
While trying to setup audits, the sql server shows "Auditing is not
available in this edition of sql serer. (Micosoft SQL serve,r error:33075)"
As for as the features for Standard edition, auditing f ...
|
Bogus CPU figures in profiler trace
Mon, 22 Sep 2008 17:42:01 -0700
I analyze a trace from production, shows an SP with certain parameters needed
30 seconds of CPU, out of a duration of 60 seconds, doing about 600k reads.
On my dev box, the same code and the same data needs 10 seconds of CPU out
of a duration of 10 seconds, doing about 600k reads. That is, it was slower
at ...
|
Maintenance Plans on Multiple servers using single Master server
Mon, 22 Sep 2008 12:25:03 -0700
Hi All,
Recently I have been tasked to consolidate and reorganize all sql
maintenance plans
(like DB disk backups, DBCC checks, rebuild index etc.) across all the sql
instances to ease maintenance and better monitoring for DBA's.
I am thinking of setting up of Master server and centralize all maintenance ...
|
Views and Indexes
Mon, 22 Sep 2008 20:14:50 +0100
I would like to use views more in the architecture of application. I am told
by my manager that in some situation they don't use indexes properly. My
manager's away so I can't ask him. Can anyone shed any light on what he
means?
...
|
MS SQL 2008 installation issue with Vista x64
Mon, 22 Sep 2008 12:03:15 -0700 (PDT)
Hey guys,
I recently picked up a new x64 laptop and I can't install MSSQL 2008
Developer on it. As you as you run it, it says that .NET 3.5
installation failed and that I need it to continue the installation.
However, I've check my laptop and I have both 3.5 x86 and x64. What
could be going on?
Thanks
Maz ...
|
seeking on-line example of dynamic database
Mon, 22 Sep 2008 11:03:01 -0700
Greetings. I am seeking a web site that exhibits the following dynamic data
format:
The user is able to select data to be displayed, hit a submit button, and
the data is displayed. If the user then selects different data and submits,
the new data is displayed.
I need this to demonstrate to my team what I ...
|
|
|
How to find out if a DTS or SSIS packege is password protected
Mon, 22 Sep 2008 10:24:13 -0700
Is it possible to query a system table/view in SQL2000 and SQL2005 and find
out if a DTS or SSIS package is password protected?
On one of our SQL2005 instances we would like to prevent file system storage
of SSIS packages. Is this possible to do by editing a system setting?
Thanks,
Jay ...
|
search on the table
Mon, 22 Sep 2008 09:26:03 -0700
Hi,
We have a job inserting data into table1 every night, then during the day,
we need to run a sp to do a search on table1. This database is set auto
update statitics and auto create statitics, anything else I need to do with
the searching process regarding the performance respect.
Thanks,
sg ...
|
index help
Mon, 22 Sep 2008 08:15:01 -0700
We are using sql 2000, then every night we have an insert procedure to load
employee info into a table db1. During the day, we have seperate sp1 to
search db1, it is very slow. Then we added the index for search on db1, it
gets faster. However, it affects the loading process at night. Is it possible
to achie ...
|
|
|
