SQL 2005 attemted to read or write protected memory.
When we works on the SQL server itself with the SQL Server Manager, we
receive regular the following error message:
attemted to read or write protected memory. this is often an indication that
other memory is corrupt.
Google find the following for me, http://support.microsoft.com/kb/926421/,
but this update is for a 32 bit environment.
Do one of you know a solution for me, or tell me where I can find the 64bits
hotfix?
|
3/11/2010 8:46:01 AM
|
0
|
=?Utf-8?B?U2VudCBhbmQgcmVjZWl2ZSBtYWlsIFNCUzIwMDg=?= <SentandreceivemailSBS2...@discussions.microsof
|
|
Evevalte America
Does anyone know if the Elevate America program includes SQL Server training
and/or certification?
|
3/11/2010 2:42:31 AM
|
0
|
"Alan" <a...@goaway.xxx>
|
SQL2005 x64 Developer on Win7 - Memory Mgmt
Greetings,
I'm doing some development work and I've got the following configuration:
- Win7 x64 Ultimate
- SQL Server 2005 Developer x64, SP3
- 8 GB RAM
The problem that I'm having is that the SQL Server Process is maxing out at
~150 mb, where this is really killing the performance of sql server.
I used to have the system running Vista x64 and using the same database
doing the same queries, sometimes I'd get SQL Server using up to 5.5GB of
memory when doing some intensive queries.
I'm no real SQL configuration whiz, but in the past, I've never had to do
anything to
|
3/11/2010 1:00:01 AM
|
0
|
=?Utf-8?B?bWRqdGxqYW1q?= <mdjtlj...@discussions.microsoft.com>
|
SQL service broker
It appears that the service broker newsgroup may be dead ?
I apologize if some view this a cross posting...
I have a process whereby I would like to accomplish the following...
The setting includes many client workstations using a VB.net application to
communicates with a database via ADO connections.
The workstations will be adding "transactional" information into some sql
server tables.
Been there, done that... so far, so good...
Unfortunately, that is only half of the "transaction"...
Once the first half of the transaction has been successfully committed to
the sql t
|
3/11/2010 12:23:51 AM
|
0
|
"Alfred" <aaanone>
|
ghost cleanup task
I have a server running win2003, sql server 2005 sp3. Yesterday appears
the ghost cleanup task on the server. I see that this task increese in
cpu time and it cause that the cpu has 100% used.
I reboot the server and the task appears again. I read on Internet many
options and apply it but it doesn�t work.
Do someone know why the process appears even after the server was
shootdown?
Do you know a way to avoid this task use a lot of cpu?
How can I identify the process that is causing this task.
Thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex
|
3/11/2010 12:11:26 AM
|
0
|
MariaGuzman <maisaguz...@yahoo.com>
|
SQL Server 2005 Rename Instance Name
Is it possible to rename SQL Server 2005 instance name without creating a
new instance within SQL Server?
Please help me with this issue.
Joe K.
|
3/10/2010 9:44:01 PM
|
1
|
=?Utf-8?B?Sm9lIEsu?= <J...@discussions.microsoft.com>
|
How to configure SQL server 2005 to store/search multiple language
Hello,
What specific areas do I have to take care of in order to meet the following
requirements:
1. The database needs to store correctly content in English, Spanish,
French, Japanese, and Korean.
2. The database needs to return correct results in full-text and field-based
search for searches in the above languages.
Thanks very much in advance for any info!
-David
|
3/10/2010 7:21:02 PM
|
2
|
=?Utf-8?B?TUREQw==?= <M...@discussions.microsoft.com>
|
DBTYP.NET Studio 2010 - Database Comparison Suite Released
DBTYP.NET Studio 2010 - Database Comparison Suite Released
Vienna, Austria - March 8, 2010
Today, BYPsoft announced the availability of DBTYP.NET Studio 2010, the
newest version of the cross-database comparison tool that compares SQL
Server, MySQL and Oracle databases (schema and data). DBTYP.NET Studio 2010
is available for download from http://www.bypsoft.com.
With its rich support for schema and data cross-database comparison,
DBTYP.NET Studio takes the mystery out of databases, making their comparison
practical and easy for programmers and database administrators everywh
|
3/10/2010 7:18:26 PM
|
0
|
<Tommy>
|
Transact SQL teaser
Hi Gurus!
I need your immediate help with a brainteaser…
My problem:
I need a setbased SQL for loading a Data warehouse. I have a dataflow with
many rows per category. These rows should be grouped per date interval and ID
and category. min (from_date) and max (to_date) should be delivered as in the
result below.
I can easily handle this with a cursor, but that’s to slow…
What would you suggest?
Best, Jocke
The example:
ID Category from_date to_date
1691789 43 2004-09-01 00:00:00.000 2005-03-01 00:00:00.000
1691789 43 2005-03-01 00:00:00.000 2005-09-01
|
3/10/2010 7:11:01 PM
|
2
|
=?Utf-8?B?Sm9ja2U=?= <Jo...@discussions.microsoft.com>
|
Log Shipping Problem -Last Backup File and Last_backup_date
The above two columns in table log_shipping_primary_database dont appear to
be getting updated with the latest trans log backup information causing
alerts. The trans logs are being backed up copied and restored sucessfully
to the secondary database.
Somethings out of sync but the information in the logshipping tables looks OK.
Any ideas on how to jumstart the updating of these two columns?
thanks
|
3/10/2010 5:06:03 PM
|
1
|
=?Utf-8?B?dG9t?= <fro...@nospam.nospam>
|
SQL Express database size increases dramatically.
Hi,
I am using SQL Express for a small application. I noticed the size of
database increases by 10 - 15 folds everyday after database is 350mb+.
Usually everyday increase is 2mb per day, but now it is more than 20mb
per day. There is no change in operation. Pls suggest if there is any
flaw in SQL Express.
According to spec of SQL Express, it can be used until 4gb size. But
the rate it is increasing now, it will be 4gb in no time.
Version I am using is SQL Express 2005.
Anyhelp.
Regards,
Biswa.
|
3/10/2010 1:07:25 AM
|
5
|
brnaya...@yahoo.com
|
Scheduling legacy DTS packages in SQL 2008 SP1
I have hundreds of DTS packages that I brought over from SQL2000 into
a SQL 2008 Enterprise SP1 64 bit environment, on Windows 2008 R2 64
Bit. Our plan is to bring everything over as is, and convert to SSIS
as time permits. I've run into a bit of a stumbling block hopefully
someone out there can assist me with.
I can run the dts package by running it at the command line via
DTSRUN /S
I can run the dts package by hand via the backward compatability
design time components
when I schedule a job to do DTSRUN as a cmdexec the job fails saying
it cannot find the specified file,
BUT
|
3/9/2010 9:27:16 PM
|
5
|
David Hay <david....@gmail.com>
|
Forums versus newsgroups - can you indulge a SBS MVP by answering some questions?
As an SBSer since I have SQL on my server I feel like SQL is family so
if you'll indulge me in a fishing expedition on forums versus newsgroups.
I need to pick your brain a bit if you don't mind? Can I ask some
fishing expedition questions because I want to see if my thoughts are on
track with others. Just want to see if my thoughts are out in left
field or what. I know why I like what I like but I want to know from
someone else what they like and why.
Do you like forums over newsgroups and if so why?
Do you like newsgroups over forums and if so why?
How did you firs
|
3/9/2010 8:56:57 PM
|
0
|
Susan Bradley <sbrad...@pacbell.net>
|
space in log file cannot be reused
Im a GP tech and I recently ran a GP company DB upgrade on SQL05 - 5
companies made it - one did not. I tried 2 more times and ran into this
error each time:
transaction log for company ID full. To find out why the space in the log
cannot be re-used see the log_reuse_wait_desc column in the sys.databases?
How do I open that table in temp DB to view that column?
and it also states to remove the temporary table at the database level.
after several repeated MBS GP support request yesterday that led no where -
I am seeking SQL specific assistance
--
S Ibbotson
MCITP -
|
3/9/2010 7:09:01 PM
|
4
|
=?Utf-8?B?YWRhdGFzeXM=?= <adata...@discussions.microsoft.com>
|
Capture Bulk Insert Duplicate Rowcount
SQL Server 2008 Std, SP1, Windows 2008
I am using bulk insert to load a large amount of data into my database. The
tables have a primary key with the ignore duplicate values turned on.
Everything works just fine, but I would like to track the number of rows from
the input file that do NOT get loaded due to a duplicate value. Does anyone
know of a way to capture this?
Much thanx for any help with this...
--
Jeff Carrington
DBA
comScore Inc.
|
3/9/2010 5:50:01 PM
|
3
|
=?Utf-8?B?SmVmZiBDYXJyaW5ndG9u?= <JeffCarring...@discussions.microsoft.com>
|
Default Degree of Parallelism on SQL Server 2005
Is there guidelines, suggestion or could somebody point me to articles which
discuss how to determine the optimum degree of parallelism?
I suppose the biggest factor is going to be cxpacket waits. My problem is
how do I determine when cxpacket waits exceed the treshold.
Thanks in advance
|
3/9/2010 5:40:01 PM
|
10
|
=?Utf-8?B?Ukc=?= <...@discussions.microsoft.com>
|
SQL SERVER 2005 Database Engine Tuning Advisor Error "Statement does not reference any tables"
hi guys,
I had a trace file from production (almost all stored proc execution
events) and I'm using it to tune agaist the exact copy of production
database. After running an hour, the progress shows in the Reason
column almost all "Statement does not reference any tables" and
there's no recommendation at all. In the statement column for DTA, it
shows no real sql statement from the event but some weird statements
like "END COMMIT TRAN", "RETURN @@ERROR" etc. I don't understand why
DTA can't parse stored proc to see which tables are used but generate
this error. Could someone here giv
|
3/9/2010 5:23:04 PM
|
0
|
mirthcyy <mirth...@gmail.com>
|
Attunity with SQL Server
Hello everyone,
I just wonder if there's anyone who uses\used Attunity with their SQL Server
environment?
I would appreciate if you have any experience, suggestion or tips to share
with me.
Thanks,
Ekrem Önsoy - SQL Server MVP
|
3/9/2010 3:55:01 PM
|
0
|
=?Utf-8?B?RWtyZW0gw5Zuc295?= <Ekremn...@discussions.microsoft.com>
|
SQL Server 2008 - Performance Alert Recommendations
Hello,
I have just completed a migration from SQL Server 2000 to 2008 and am in the
process of applying the finishing touches on the SQL 2008 server. I am
currently creating Alerts and was looking for recommendations on what
performance alerts to add. I have added a few obvious ones like Deadlocks =
1 and errors/sec > 0 and as I am new to SQL Server 2008 I was wondering what
other counters people alert on regularly. I did some quick Googling but
couldn't find any satisfactory articles.
Some quick specs on my system, the database is primarily a back-end for our
Intrane
|
3/9/2010 3:47:01 PM
|
1
|
=?Utf-8?B?SmVmZiBXYXNraWV3aWN6?= <JeffWaskiew...@discussions.microsoft.com>
|
Index on a Timestamp Column
I have been asked to index the Timestamp column on our main source system
database (1.3TB). The proposed index's are to help decrease the load time of
our datawarehouse. My question is, are timestamp columns good candidates for
indexes. (The warehouse selects between two timestamp values) considering the
constant updates on the index this will cause?
|
3/9/2010 1:34:07 PM
|
5
|
=?Utf-8?B?Q29saW4=?= <Co...@discussions.microsoft.com>
|
Is there any way to check GRANT VIEW DEFINITION ?
There is a request to grant privilege to a particular user for viewing
stored procedure source code for all databases.
We searched the web and applied the following script:
USE master
GO
GRANT VIEW ANY DEFINITION TO User1
Is there any way to check the view definition has been granted ? We
have tried sp_helprotect for one of those databases but there is no
action shown as VIEW DEFINITION.
Your advice is sought.
Thanks
|
3/9/2010 8:31:34 AM
|
4
|
Patrick <Patr...@discussions.microsoft.com>
|
SQL Server Drops connection after long timeout with replication partner
Hello,
I have both SQL server 2005 that have replication set-up between eachother.
It seems that when my site-to-site VPN drops for a medium period (such as
1hr, 2hr) bothe servers no longer respond to client connections.
Restarting the "SQL server Browser" service on both machines instantly
resolves the problem.
Extra info: Both servers reside in their own site with in each site 2DC (1
GC per site + 1 DC)
Is there a way of solving this issue ?
--
Guillaume Coign�
MCP, MCTS, MCSA, MCSA Messaging
Cafe.be
Marksesteenweg 35
8500 Kortrijk
Mob: +32 (0) 496162505
Email
|
3/9/2010 8:14:48 AM
|
0
|
=?iso-8859-1?Q?Coign=E9_Guillaume?= <guillaume.coi...@dinckers.com>
|
Long execution time for UPDATE tbl SET @var = col = {expression} under SQL2000
Folks:
We have SP queries like:
UPDATE tbl
SET @var = col = col + 1
WHERE keycol = x; -- update single row, indexed
This query can sometimes sit for several _minutes_ on a MSSQL2000SP4 box,
but we don't see similar delays on a MSSQL2000SP4+postSP4hotfixes box under
large testing load.
Is the performance of this type of query under SQL2000SP4 a known problem
that was corrected by a post-SP4 hotfix? {/me crosses fingers}
--
John Hardin KA7OHZ
Senior Applications Developer, BI Specialist
EPICOR Retail
web: http://www.epicor.com
voice: (425) 245-1800
fax: (
|
3/9/2010 12:47:27 AM
|
3
|
"John Hardin" <jhar...@epicor.com>
|
Primary Key - string or integer
What do you thing how slow will that be if string is used as primary key
field type?
I know most of the primary key defined as integer type (eg.auto-increment).
We are using string as primary key field type: VARCHAR(36).
We use the GUID type string.
|
3/8/2010 11:49:50 PM
|
5
|
"Alan T" <alan_NO_SPAM_pl...@yahoo.com.au>
|
no value to be substituted by NULL word
Hi,
I have a table with 5 columns where the last column doesn't have any
values. I have to write a query to pull all information from the
table (select * from table) but the last column should show word
"NULL" as opposed to nothing. The "NULL" word should only be shown in
the query result set and nothing should be changed in the table
itself.
Thank you,
T.
|
3/8/2010 10:07:54 PM
|
1
|
tolcis <nytolly...@gmail.com>
|
sa not found
SQL server was installed on a server recently for a Cisco application. This
application's setup connects to the SQL Server and creates a database. The
application setup completed after creating a new database. Now when I logged
in I found that the sa login is now missing under Security tab. This is SQL
2005. Please help
|
3/8/2010 8:16:01 PM
|
1
|
=?Utf-8?B?cm9ubmll?= <ron...@discussions.microsoft.com>
|
A Question about SQL Server 2008 Installation
There are 6 cumulative updates after SQL Server 2008 SP1. If I setup a new
server, after install SP1, should I install each of the cumulative updates,
or just install the last one? In other words, does the last update include
all previous updates?
Thanks,
Lijun
|
3/8/2010 7:49:42 PM
|
2
|
"Lijun Zhang" <sonyzhan...@yahoo.com>
|
VS2008 and sql server - from 2005 to 2008 ?
I installed VS2008 SP1 on one machine, somehow I have also sql server 2005
and 2008. On other machine I installed SP1 and only have 2005 sql server. I
checked the rest of downloaded plugins and other VS stuff, but can't figure
out how I got the server 2008.
|
3/8/2010 7:37:43 PM
|
4
|
"Mario" <pas...@po.t-com.hr>
|
Identity column not being reseeded
Hi,
We are in the process of migrating from one DC to another. I setup a
transactional replication using SQL backups for a database that only has two
tables which are very actively updated. Here are the steps that I followed in
the order:
1) Setup distributor.
2) Restored full backup followed by T-Log backups (from publisher db to
subscriber db) until the production maintenance window started.
3) after the maintenance window started i took last log backup and restored
at the subscriber.
4) Setup publisher and set allow initialization from backup to true.
5) setup subscribe
|
3/8/2010 5:44:01 PM
|
1
|
=?Utf-8?B?TWFsaWs=?= <Ma...@discussions.microsoft.com>
|
DateTime. Stored with timezone information or not
One thing I have been blessed from until now is to deal with datetimes
for different time zones.
Are datetime saved as they are (not taking timezone into account) or
are they converted to UTC?
If it does I guess the timezone the server is running in is used (or
more correctly what timezone Windows that the server is running under)
when saving or displaying date time information.
Note: I am talking about DateTime and not the new data type
DateTimeOffset in 2008.
|
3/8/2010 12:52:16 PM
|
2
|
Magnusb <magn...@sbbs.se>
|
What will happen to transaction log if we take a full backup ?
We are running daily database backup and transaction log backup every hour.
We would like to know if we make a full backup mid way the day (Like:
12:20pm), can we still be able to restore point in time to a time before
that full backup (Like: restore from last night backup and transaction
log backup to 11:15am) ?
Thanks
|
3/8/2010 7:45:27 AM
|
6
|
Patrick <Patr...@discussions.microsoft.com>
|
Move database from sqlexpress to sql standard -wss
Hi all
dont know if this is a sharepoint or SQL post so will start here. I have a
windows sharepoint services 3 database hosted on an SQL express2005
instance. I need to move it to an SQL 2005 standard instance on the same
machine(we are phasing out the SQLexpress). Is there a procedure for
this?
--
Craig
|
3/7/2010 7:01:34 PM
|
9
|
"News" <...@no.com>
|
newbe question
Hello everybody,
I have an VB.net app with a ms sql server database. If I want to deliever
the application I should send the database information as well.
My question: what is better strategy - to send CreateDatabase query or
backup of the database to my customer. What is easier for the customer to
get fast the database structure - to create it from the sqlquery or to
recreate it from the database.bak?
I would like to avoid all problems and to make the job for unexperienced
administrators easy.
If the customer installed sql server - what tools does he need to be able to
use sql
|
3/7/2010 3:02:13 PM
|
4
|
"Uwe Conradi" <conr...@arcor.de>
|
send automatic information to my table on the second sql server 2005
Hello Team
There is a table on my first sql server 2005 , we enter many information to
this table. Also there is same table on my second sql server 2005. I want to
send information to my second sql server everyday.
Thanks for Help
|
3/6/2010 9:01:52 AM
|
1
|
"lassaad" <u58...@uwe>
|
Uninstall SQL2005 Reporting Service
Hi..
I try to uninstall SQL 2005 reporting service from add/remove program,
but it didn;t work because it's still there.
Does anyone has any idea on how to remove it once & for all?
Thanks.
|
3/6/2010 4:38:31 AM
|
1
|
=?Utf-8?B?bWltaQ==?= <m...@discussions.microsoft.com>
|
SQL 2008 R2 - ALTER INDEX performance degredation with compreessed indexes
I'm doing initial tests with different aspects of performance using PAGE
compression with SQL 2008 R2.
I've noticed that rebuilding indexes using "ALTER INDEX" takes longer time
with PAGE compressed indexes than with uncompressed indexes.
Is this to be expected in general? - If so, can anyone point me to the
documentation?
Br,
Mikael Sorensen
|
3/5/2010 10:11:50 PM
|
5
|
"Mikael Sorensen" <...@spam.com>
|
SQL 2005 & server side trace
Hi,
I am trying to set up a server side trace where it will collect logins
and objects access by a list of users in one database. The problem I
am running into is using more then 2 sp_trace_setfilter to capture
more then 1 user name. Either I get nothing or get everyone and that
is not what I want.
Here is a snippet of the code I'm running via a query window.
exec sp_trace_setfilter @traceid, 3, 1, 0, 29 -- dbid for
MyDatabase
exec sp_trace_setfilter @traceid, 11, 1, 6, N'%joesmith%' -- any
version of a user with joesmith
exec sp_trace_setfilter @traceid, 11, 1, 6, N'
|
3/5/2010 9:48:43 PM
|
4
|
GrampaJoe <joey...@gmail.com>
|
Change sa password SQL Server 2005
I need to change the sa password for one of my production servers.
Nobody knows what the current one is and Dynamics GP requires the sa
credentials for some administrative tasks.
I have access to the server and can easily change the sa password, my
question is:
What consequences could this bring to the system functionality?
Can you think of some ways this change could affect the server other than
jobs failing if they are "owned" by sa?
THANKS!
Lee.
|
3/5/2010 5:56:00 PM
|
1
|
"Lee Borio" <leebo...@bellsouth.net>
|
trace logins
How do I trace all logins to a specific database?
I want all successful and failed accesses to some of my databases in my sql
server.
1. I have about 100 databases, I want to trace accesses to about 20 of them.
2. The databases has several logins each, I don't want to search in logs for
every single possible login name, which sometimes are AD groups/accounts
(several thousand possible).
3. The databases is sometimes taken offline, the users gets an error - is
this possible to trace/log this in any way? I don't mind if failed logins
(wrong user/pass) also gets logged.
4. The
|
3/5/2010 4:47:09 PM
|
1
|
"Anonymous" <bi...@microsoft.com>
|
impact of adding index to column
Where I work we have a SQL Server 2005 DB. There has recently been a
new business requirement that will require that we do regular (daily)
updates to one of our primary tables. This update will be based on
the value of a non-index varchar column. In other words the WHERE
clause for the update includes a condition on this non-indexed
column. This column was added when the table was originally created,
without any knowledge of how the column might need to be used. Now
(some 10 years after the original DB design) the column is used for
many different purposes and therefore holds many
|
3/5/2010 4:18:19 PM
|
4
|
Steve <sredm...@rfcorp.com>
|
Recommendations for self-teaching material for 2005/2008 Business Intelligence Platform?
Hello,
can someone recommend a self-teaching material for the Business
Intelligence Platform 2005/2008 (Analysis Services, Reporting Services,
Data Mining, etc.)?
Thanks!
Thomas
|
3/5/2010 11:56:53 AM
|
2
|
Thomas Steinmaurer <t.steinmaurer_dontbugmewithsp...@upscene.com>
|
Secure location to store keys ?
Hello
I would like to use the database encryption feature of SQL Server 2008. My
security officer agrees, but he asks me to define the policy to store the
certificate and the private key. He says that our safe is not safe enough
(remember 9/11), that we should think of a bank safe, etc. What is the best
practice ?
Pierrot
|
3/5/2010 11:17:25 AM
|
3
|
"wpher56" <jsteal...@hotmail.com>
|
Is there any access right for Stored Procedure ....
If we create an account that have read access to a database in SQL
Server 2005, can it read the stored procedure in that DB OR other
privilege has to be granted ?
Thanks
|
3/5/2010 10:28:18 AM
|
3
|
Patrick <Patr...@discussions.microsoft.com>
|
Stored Proc to find matches
Hi guys,
I have been asked to write a tored proc that returns all the rows from
a single table (easy enough), where words from an input parameter,
comma separated, are found in the 'description' column.
So, the 'WHERE' clause is a bit tricky.
An example of an input parameter would be:
'fraud, murder, vehicle theft, aviation'.
So, I need to search the description column and return the row if any
(or all) of the matches are found.
Could someone guide me here? I guess the comma separated text firsly
needs to be split up somehow? Or, could dynamic SQL (Yuk, not sure
it's a g
|
3/5/2010 3:18:28 AM
|
8
|
Craig Lister <cdotlis...@gmail.com>
|
SRID values for Spatial Data Tyoes in SQL Server 2008
Hi There
I've been investigating spatial data types in SQL Server 2008 for my
customers.
It appears only certain coordinate systems are supported by SQL Server 2008.
How do I request that the missing coordinate systems for my country (New
Zealand) get added?
More details below:
For the geometry data type:
None of the local projected coordinate systems for NZ are supported in SQL
Server 2008. These supported EPSG codes (SRIDs) are stored in the
sys.spatial_reference_systems system view in a SQL Server 2008 DB. (NZ
projected EPSG codes are 27200 (New Zealand Map Gri
|
3/5/2010 2:03:01 AM
|
0
|
=?Utf-8?B?Um9iZXJ0IFBhcnNvbnM=?= <Robert Pars...@discussions.microsoft.com>
|
Sql MDF to Access 2007 format
Hi
I have SQL2005Express with a small 7MB MDF that I would like to convert to
Access or Excel 2007.
Not very well versed in that process and would love any assistance as to the
best method and how to
many thanks
-- Marcaeu
|
3/5/2010 1:59:38 AM
|
2
|
"News" <...@no.com>
|
Can't insert Char(1) into SQL Server from Stored Procedure
Hello
I am trying to insert a char(1) field into a table from an ASP.Net/C#
application.
At first I was inserting rows into the table but none of the columns that I
was inserting the rows into were char(1) columns, they were mostly int and
varchar columns.
Then I found out that there was one column in the list that was not supposed
to be an int column but instead it was supposed to be one of the char(1)
columns into the table.
So I replaced the int column in the list with the char(1) column and since
the value of the char(1) column resulted from a CheckBox ('Y' or 'N
|
3/4/2010 11:33:01 PM
|
1
|
=?Utf-8?B?SkI=?= <...@discussions.microsoft.com>
|
Allowing Vendor to Place SQL Server Instance w/o giving customer a
We have a vertical market vendor who we bought a program requesting to place
a separate SQL Server instance on our server without giving us admin rights.
I understand that they want to protect their schema and want to keep us from
writing to the DB, but I feel very uncomfortable with this. What would you
do? Thanks.
|
3/4/2010 3:13:02 PM
|
10
|
=?Utf-8?B?RWQgUw==?= <...@discussions.microsoft.com>
|
Access to SQL Server from DMZ - is Mixed Mode authentication required?
Hi,
Can you access SQL Server 2008 in an intranet from a DMZ web server
using Windows Authentication? Or do you need Mixed Mode authentication
set up?
In other words, can you pass Windows user account and password through
on a connection string?
Cheers,
James
|
3/4/2010 12:13:35 PM
|
1
|
JimLad <jamesdbi...@yahoo.co.uk>
|
[SS 2000] Mirroring of only 1 table
Hi,
in SQL Server 2000, is it possible to mirror just one table?
Or only several tables of the database.
Thanks in advance.
Luigi
|
3/4/2010 12:08:01 PM
|
3
|
=?Utf-8?B?THVpZ2k=?= <Lu...@discussions.microsoft.com>
|
ORDER BY not working in VIEWS?
Hi,
(SQL Server 2005)
It seems ORDER BY does not work when presenting data using a VIEW? If I
enter design mode and "execute SQL", the data is sorted, but if I "Open" the
view, the data is not sorted.
--
Gerry Hickman
London (UK)
|
3/4/2010 11:57:12 AM
|
6
|
"Gerry Hickman" <gerry666...@newsgroup.nospam>
|
NO LOCK
Hi guys,
What is the process of though you use, when thinking about the NO LOCK
option? do you use it everytime you're doing a SELECT, or only when
it's a hefty one using loads of JOINS? Basically, when shouldn, and
shouldn't it be used?
Also SET NOCOUNT... Should that be used in all Stored Procs?
|
3/4/2010 4:51:28 AM
|
8
|
Craig Lister <cdotlis...@gmail.com>
|
How do you get a database into recovery mode.
Here is the scenario.
I have a database on an equallogic box. The equallogic box does a snapshot
at 10:00pm, on sql server i am doing transaction log backups every 10
minutes. The database breaks at 10:30, so I restore to the 10pm
snapshot(this is not a sql snapshot). How do I get the database into
recovery mode, so I can apply the transaction logs?
|
3/4/2010 3:53:01 AM
|
8
|
=?Utf-8?B?TWFyaw==?= <M...@discussions.microsoft.com>
|
SQL Server Agent Wont Script Step
SQL Server 2005 SP3.
When I go into a SQL Agent step and select the Script button at the top,
then select Script To Clipboard I usually get "There is no action to be
scripted". Occasionally, it works without that message but usually I get it
most of the time. Now, I can script the SQL Agent Job but the step scripting
is buggy. Any ideas how to fix this?
|
3/3/2010 2:51:01 PM
|
1
|
=?Utf-8?B?TUc=?= <...@discussions.microsoft.com>
|
DBA Job Change
After working for years as a DBA for my company I would like to transition to
another position within the corporation. The company has a large IT
department, however I'm not sure what I can transition to being a DBA. I'd
like to hear from other DBA's out there that have transitioned to other jobs
within or outside their company and if they successfully made the transition.
What did you transition to? What IT jobs would a DBA qualify?
Thank you very much in advance!!
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201003/1
|
3/3/2010 1:51:36 PM
|
0
|
"fnadal via SQLMonster.com" <u10...@uwe>
|
DBA Job Transition / Change
After working for years as a DBA for my company I would like to transition to
another position within the corporation. The company has a large IT
department, however I'm not sure what I can transition to being a DBA. I'd
like to hear from other DBA's out there that have transitioned to other jobs
within or outside their company and if they successfully made the transition.
What did you transition to? What IT jobs would a DBA qualify?
Thank you very much in advance!!
--
Message posted via http://www.sqlmonster.com
|
3/3/2010 1:51:14 PM
|
0
|
"fnadal via SQLMonster.com" <u10...@uwe>
|
CHECKDB loop SQL 2008
On my SQL 2008 SP1 server it seems there is a loop of events for 3 of
the databases existing on this server.
On the Windows Application event log there are intermitently logged events
17137 Starting up database 'db'
and then
17573 CHECKDB for database 'db' finished without errors on yyyy-mm-dd
07:13:53.453 (local time). This is an informational message only; no
user action is required.
The date is from a previous maintenance plan. These avents are logged
every 20-30 minutes. Same events on SQL logs, too.
|
3/3/2010 1:27:49 PM
|
2
|
Daniel <dvasil...@hotmail.com>
|
SQL - Relational DBs Overview Resources
Hello there,
Are there good resource documents on the web somewhere providing a
very good rundown of what relational DB's are, how they are used,
tables/constraints/relations/etc, all the usual conceptual suspects, in
roughly 100 pages or less?
A friend sort of inherited a small scale DB without prior knowledge
and is unfortunately tasked with coming up to steam very rapidly :). I'm
hoping there is a good document somewhere to help him.
Thanks for any thoughts and your time,
Joseph Bittman
MSCD .Net, Former DPM MVP
|
3/3/2010 9:31:02 AM
|
2
|
=?Utf-8?B?Sm9zZXBoIEJpdHRtYW4=?= <RyanBitt...@msn.com>
|
Dump Database instantly
Hello,
I would like to capture the contents of a database (complete) at a
particular instant. This could be triggered for different reasons. At any one
of these trigger events (trigger: not to be interpreted as SQL trigger) the
entire database should be dumped in whatever state it was. This will be used
for analysis later on.
How can I achieve this with the least performance impact on the database,
application and server?
Cheers
|
3/3/2010 5:38:01 AM
|
6
|
=?Utf-8?B?c3FsY2F0ekBob3RtYWlsLmNvbQ==?= <sqlcatzhotmail...@discussions.microsoft.com>
|
copy entire database over to linked server
I just setup a linked server that is provided through our ISP. Our database
is setup as merge replication that is pushed to four remote locations all
running sql server.
I want to setup the linked server with the same database. What is the best
way to do this? Can I configure merge replication with the linked server so
it is always up to date? We are using SQL SERVER 2000
WB
|
3/3/2010 12:47:08 AM
|
17
|
"WB" <none>
|
orphaned transactions
Hi
I have located some orphaned transaction in "sys.syslockinfo WHERE req_spid=
-2", but I cant see them using sp_who or sp_who2. I can still kill these
using UOW.
Any idea why these are not listed in sp_who with spid=-2?
thanks in advance
--
Regards
priw
|
3/3/2010 12:22:08 AM
|
1
|
=?Utf-8?B?UHJpbmN5?= <non...@discussion.mc.com>
|
DBCC SHOWCONTIG
What does it mean when this report shows blank under index name?
Thanks in advance
|
3/2/2010 9:10:01 PM
|
2
|
=?Utf-8?B?Ukc=?= <...@discussions.microsoft.com>
|
SQL Server 2005: Management Studio missing after setup
hi everyone
i already posted this in the setup group but couldn't get a reply up until
now.
yesterday i was experiencing some issues trying to install SQL Server
2005 on my Windows Server 2008 R2 box (64-bit).
after i completed the installation i can't seem to find the SQL
Management Studio. i have selected all components to be installed, including
"workstation components, books online and development tools".
i tried searching for SQLWB.exe but couldn't find anything.
thanks for your help!
cheers
marc
--
MCP, EPM consultant
Zurich, Switzerland
|
3/2/2010 8:35:02 PM
|
2
|
=?Utf-8?B?TWFyYyBTLg==?= <mar...@discussions.microsoft.com>
|
Query Database Properties
I am hoping this is a relatively easy one...
I need to create a document that includes several key items from a specific
SQL Instance:
* Server Name
* Database Name
* Owner
* Date Created
* Size
* Table Name
* Schema
* Data Space
* Row Count
I can see this information in the properties, but want to know how to write
a query to produce a table with the information I need, but I don't even know
what database/table to query...
I greatly appreciate any assistance!
Regards,
Ray
|
3/2/2010 8:34:01 PM
|
1
|
=?Utf-8?B?UmF5cG9ydGluZ01vbmtleQ==?= <RayportingMon...@discussions.microsoft.com>
|
Reinstall necessary to rollback SQL 2005 SP3?
I'm very confident that SP3 will be installed without a mishap, but the
boss is insisting on a fallback plan. So, I started investigating what
it would take to roll back to SP2, and was alarmed to find that an
uninstall/reinstall of SQL Server (along with a couple other hoops to
jump through) was necessary to roll back from SP2.
Is this still the case for SP3?
--
Sick of googling,
Bob Barrows
|
3/2/2010 8:30:52 PM
|
3
|
"Bob Barrows" <reb01...@NOyahoo.SPAMcom>
|
Users with "VIEW SERVER STATE" only see current session
If I login as sa or a user with "VIEW SERVER STATE" permission, and query
sys.dm_exec_requests, I see only sessions < 50 and the session for the user
doing the query.
As I understand it, I should be able to see all sessions for all users on
the server. If my understanding is not correct, let me know. If my
understanding is correct, please advise how to resolve the situation.
I would like to get a query something like the following to work:
SELECT session_id, text
FROM sys.dm_exec_requests AS r
CROSS APPLY
sys.dm_exec_sql_text(sql_handle) AS s
WHERE session_id > 5
|
3/2/2010 6:11:02 PM
|
2
|
=?Utf-8?B?SGFndXM=?= <Ha...@discussions.microsoft.com>
|
plan guide question
Hi, We have stored procedure that performs well on one server, but it takes
forever on the other. Databases are the same (backup&restore). Hardware wise,
servers are approximatelly the same. I'm wondering if I can generate plan
quide for this stored proc on one server, and implement it on the other?
Thanks
|
3/2/2010 4:48:07 PM
|
2
|
=?Utf-8?B?UGVkamE=?= <Pe...@discussions.microsoft.com>
|
table design question
I have table of 40 milion rows (sql 2005). There is one column, Id, which is
integer (basically month), and there are 20 different values for this column
(around 2 million rows per id value). At the same time, there is very long
primary key on this table (12 columns, around 400 bytes), and nonclustered
index on this primary key. Table is being accessed frequently by Id, so I
created clustered index on this column (usually, developers create temporary
tables per id, and then do further processing) to lower physical reads...
Does this sound like a desirable design? I don't want to
|
3/2/2010 3:20:01 PM
|
5
|
=?Utf-8?B?UGVkamE=?= <Pe...@discussions.microsoft.com>
|
Estimating application memory requirements
Our company has an app that is heavily dependent Sqlserver. Our test server is 64 bit with 32gb of RAM. I am hoping to
find a minimum amount of RAM to recommend to our clients. If i set the MAX server memory value low and then increase
that value with the same load, and watch the Sql memory stats will i be able to find the point at which more memory to
the process isn't adding value?
i am using this for performance counter values
http://www.sqlservercentral.com/articles/Performance+Tuning/analyzingmemoryrequirementsforsqlserver/2498/
which looks a lot like this one
http://
|
3/2/2010 2:01:23 PM
|
2
|
Dan Holmes <dan.hol...@routematch.com>
|
SQL 2005 Partitioned Table - performance issue
There is a partitioned table in our environment with 22 million records. I am
not sure of any recent changes to this table but if I execute the statement :
select count(*) from dbo.eval_loans_arc_ba ba - It takes about 20 minutes to
complete. If I execute showplan_text on the query I am seeing nested loop :
|--Compute Scalar(DEFINE:([Expr1004]=CONVERT_IMPLICIT(int,[globalagg1008],0)
))
|--Stream Aggregate(DEFINE:([globalagg1008]=SUM([partialagg1007])))
|--Parallelism(Gather Streams)
|--Stream Aggregate(DEFINE:([partialagg1007]=Count(*)))
|
3/1/2010 9:43:38 PM
|
3
|
"SAM via SQLMonster.com" <u33...@uwe>
|
maintenance plan log files
hi,
After I moved sqlagent logs to another drive (Right click Error Logs -
> Configure -> change path), I found the Maintenance plans logs can't
be generated any more. The job itseld on the job history runs
successfully but if I right click maintenance plan-> view history->
show steps and I will see the red error: "Access to the path 'C:\
\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\
\Log_Backup_Subplan_1_20100301134505.txt' is denied." The path shows
the old one. So it seems that I need to change the Maintenance plan
log file location separately but I can't find it any
|
3/1/2010 8:01:43 PM
|
2
|
mirthcyy <mirth...@gmail.com>
|
Two Basic Questions.
Hello, I am new to MS SQL 2K, migrating from MySQL.
First of all, this company I just started with has an MS SQL2K database
sitting on a windows xp pro machine. We are moving it to MS Sever instead,
don't know why it was on XP Pro - bad decision we think.
Second, in MS SQL we need to update a field during an insert event. So my
two questions are:
1) If we run the script to create the DB on the Server, can we drop the DB
and load the original DB from the XP machine? I think this is the correct
terminology.
2) We have a column in a table that we need to update via a calculati
|
3/1/2010 8:00:52 PM
|
13
|
"Marian Henna" <marion.he...@yacobe.net>
|
syslockinfo, dm_tran_locks, sp_lock - performance SQL 2008
Has anyone else noticed performance issues with querying syslockinfo,
dm_tran_locks and sp_lock since upgrading to SQL 2008?
It seems they perform the worst on named instances.
SQL 2008 Server 2008 named instance - 4 seconds
SQL 2008 Server 2003 named instance - 1 second
SQL 2008 Server 2008 default instance - .5 seconds
SQL 2005 Server 2003 default instance - .150 seconds
Dan
|
3/1/2010 7:44:01 PM
|
0
|
=?Utf-8?B?TWFybGFjb2Jh?= <Marlac...@discussions.microsoft.com>
|
'Property Owner not available' error
Using SQL Server 2005. I am unable to open the Properties window for my
database. When I right-click and select Properties, I get the following
message:
Property Owner is not available for Database '[my database]'. This property
may not exist for this object, or may not be retrievable due to insufficient
rights.
I get the same error when I try to view the Properties for the two Report
Server databases (ReportServer and ReportServerTempDB). I am able to open the
Properties window for the various system databases (master, msdb, etc), but
not my database. I've tried connecting
|
3/1/2010 3:44:01 PM
|
2
|
=?Utf-8?B?Q2FybCBSYXBzb24=?= <CarlRap...@discussions.microsoft.com>
|
FTS: can I find texts not containing a specified word?
Hi everybody,
Is there a way to find all records except the ones containing the specified
word, for example, "research''?
Unfortunately, texts don't have a common word that could be used as the
first operand for operation &!
I tried to use in CONTAINSTABLE() such combinations as "*" &! "research",
"a" &! "research", but such queries found nothing.
Thank you.
|
3/1/2010 3:01:01 PM
|
1
|
=?Utf-8?B?Vml0YWx5?= <Vit...@discussions.microsoft.com>
|
Database detach problem
Hi group,
I need to write a script which automatically restores latest backup to test
DB.
In case that test DB is in use I first have to detach it. I write these
scripts:
USE master;
ALTER DATABASE TestDB
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
USE master
GO
sp_detach_db 'TestDB'
GO
And here I get an error that "TestDB" is in use and cannot be detached.
I think that the first script should resolve this problem, but why it is
not?
SQL Server 2008
BR,
Mindaugas
|
3/1/2010 3:00:36 PM
|
11
|
"Mindaugas" <mindau...@epoint.lt>
|
Comparing two databases.
Hello readers,
We have two databases.
Database A which holds our production data. (2 Gig)
Based on a old release.
Database B which is fresh and new and only holds initial data. (200 Mb)
This is a new release.
We want to look at the inital data and was is new (and changed) in B.
Offcourse all (or most?) identitynumbers have changed in B.
The number of tables is thousands.
I think this is almost an impossible task, so I do not expact a simple
solution, but sometimes some of you have very valuable suggestions which do
help. So suggestions are welcome.
We asked the people w
|
3/1/2010 2:45:59 PM
|
13
|
"ben brugman" <...@niethier.nl>
|
Can we backup database with batch file ?
There is a request to create a batch file to backup a database in SQL
Server 2005 (In addition to database backup in maintenance plan).
Besides, in database maintenance plan, we have set up a clean up task to
clear database backup older than 1 week. If we would like to keep the
manual (batch file) backup, does it mean that the batch SQL Server
database backup file should be located in a different place ?
Thanks
|
3/1/2010 9:42:30 AM
|
5
|
Patrick <Patr...@discussions.microsoft.com>
|
Moving Resource Databases
Hi
I have tried moving all system databases (and Resource DB) on a 2005
(9.00.3301.00) 64 bit instance to another Drive following the steps outlined
in:
http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
All visible system databases were moved successfully, but the system still
looks for the Resource database in the original location So I had to move the
files back.
I am unable to attach this database to alter as it is in use.
Has anyone successfully managed to move the resourse DB and is there is
there anything else I could check to enable me to move the
|
3/1/2010 7:16:01 AM
|
3
|
=?Utf-8?B?U2hhbmUgQ2xhcmtl?= <Shane Cla...@discussions.microsoft.com>
|
Repair SQL Corrupt database
Hi,
I have a corrupt MS SQL Server 2005 database which I
am trying to repair using:
DBCC CHECKDB ('MYDB', REPAIR_ALLOW_DATA_LOSS)
Unfortunately this does not seem to fix anything.
After running the repair multiple times, I ran
DBCC CHECKDB ('MYDB') WITH NO_INFOMSGS
to see if it fixed the corruption, I noticed that is was returning a
random amount of errors on each run.
Does any know if It is the case that this database is beyond repair?
If so will the best approach be to revert back to a non corrupt
database backup and then roll forward using Transaction Logs?
thanks in
|
3/1/2010 6:22:23 AM
|
1
|
Benn <bennb...@gmail.com>
|
problem with select
Hi,
we have some tables with name begins with figures( like 98765_order).
This causes a syntax error when doing a select (select * from 98765_order).
Anyway to solve this easily?
Thanks
Luc
|
2/28/2010 12:59:01 PM
|
3
|
"Luc" <qc...@qscqs.fr>
|
Auto update statistics versus manual statistics update
I have the following two questions:
1) If auto update statistics is on, would there ever be a reason why I might
want to run update statistics manually or via maintenance plan?
2) What condition triggers auto update statistics to run? If there are many
insert/update/delete to a table, would SQL know to update the statistics
promptly?
Thanks,
Jeff
|
2/28/2010 5:30:01 AM
|
1
|
=?Utf-8?B?SmVmZnQ=?= <Je...@discussions.microsoft.com>
|
Proc cache consumed with one-time queries
In investigating memory usage os our SQL Server 2005 SP3, I noticed that
about 4.3GB of our 32GB phsyical memory was consumed by the procedure cache.
In looking at what was in the cache, I found that the overwhelming majority
of the stored plans were from queries that will never be reused. In fact
4.1GB of the 4.3GB were plans with usecounts=1.
Most of these turn out to be statements generated by Sql Server itself:
there are many that are statements generated by SqlAgent, running scheduled
tasks. Many more are the backup statements generated for log shipping. In
these cases,
|
2/27/2010 9:19:01 PM
|
6
|
=?Utf-8?B?TWlrZSBLcmFsZXk=?= <MikeKra...@discussions.microsoft.com>
|
Feasibility of using sql server express
Hi
Is sql server express ok for a 20 user contacts database which is used
mostly for queries and rarely has updates or inserts?
Many Thanks
Regards
|
2/27/2010 5:05:34 PM
|
1
|
"John" <i...@nospam.infovis.co.uk>
|
Optimizer choice doesn't make sense, goes from index seek to table scan when adding a SARG
Running on SQL Server 2008 SP1.
The following select (correctly) uses a non-clustered index on
ACCT_TYP_CD returning just over 15000 rows in 41ms. It does a single
scan and needs 37 logical reads to complete the query.
select acct_cd
from CS_FUND
where ACCT_TYP_CD = 'G';
Change the query to be this:
select acct_cd
from CS_FUND
where ACCT_TYP_CD = 'G'
and GRP_TYPE_CD = 'BKR_RULES';
and the optimizer now chooses to do a clustered index scan, taking
significantly longer, 971 ms, 8 scans and over 59,000 logical reads. It
returns no rows.
The database has auto upd
|
2/27/2010 4:27:55 PM
|
8
|
ETMcG <EricMcGr...@crd.com>
|
Supertypes/subtypes and primary keys
This is a design question. Here's hoping Joe Celko haunts this newsgroup ;)
The relevant DDL will be at the bottom of the post.
We have two entities -- sporting events and "product" which could be a cup,
shirt or a fee. Obviously, events have a number of attributes not needed
for "product". The natural PK for events is (gameid, sportid, class,
eventnum). The end user would see a combined form of the this as a "product
code", such as "ARA01". Products do not have all the various medical,
teamtype etc. flags, but share the same code-form. An example would be a
blazer, per
|
2/27/2010 6:43:34 AM
|
0
|
"Kurt Hill" <kurth...@gmail.com>
|
Sacramento, CA SQL Server group
I'm looking for people in the Sacramento, CA area that would like monthly,
or bi-monthly SQL Server User Group meetings.
Though there are several rough spots to get over (not the least of which is
a meeting place), I'm hoping that there are enough to make it worthwhile.
|
2/27/2010 3:04:00 AM
|
14
|
"Jay" <s...@nospam.org>
|
INserting Records into Table
I am in need of some help. I am very new at SQL so please disregard my
ignorance.
I have a table where I have a field named “persNo” is set up as the primary
key. This is working well as I don’t want duplicate records. The problem is
what I am trying to do is update the table with new records. The file I
have contains both New records( not in the table) and “Old” records that are
already in the table. What I would like to do is have the new Records load
and where there is a primary key violation (old records) those records are
just ignored and not loaded.
Here is w
|
2/26/2010 8:56:06 PM
|
7
|
=?Utf-8?B?QUpPTFNPTg==?= <AJOL...@discussions.microsoft.com>
|
BUY FAKE PASSPORTS OF FRANCE,FAKE FRENCH PASSPORTS FOR SALE! FAKE UNITED STATES(USA) PASSPORTS
Our team is a unique producer of quality fake documents.
We offer only original high-quality fake passports, driver's licenses,
ID cards, stamps and other products for a number of countries like:
USA, Australia, Belgium, Brazil, Canada, Italia, Finland, France,
Germany, Israel, Mexico, Netherlands, South Africa, Spain, United
Kingdom. This list is not full.
To get the additional information and place the order just visit our
website:
http://www.sellingpassports.com
>> Contact e-mails:
General support: support@sellingpassports.com
Technical support: tech@sellingpas
|
2/26/2010 7:11:27 PM
|
0
|
John Dawson <t...@sellingpassports.com>
|
Difference between ORDER BY column value and column alias between different version of SQL server.
Hi,
SQL Server 2005/2008. Is the following correct (apologies for trivial
example)?
SELECT -member_id AS member_id
FROM members m
ORDER BY member_id
--Orders by column alias
SELECT -member_id AS member_id
FROM members m
ORDER BY m.member_id
--Orders by column value
In SQL Server 2000, both the above seem to order by column alias. Is
this correct? Am I right in thinking that when I upgrade I must go
through my code and remove all the table aliases, otherwise I
potentially get a different sort order?
Cheers,
James
|
2/26/2010 6:36:06 PM
|
4
|
JimLad <jamesdbi...@yahoo.co.uk>
|
SQL Server to SQL Server over the Internet
I have a requirement, actually more of a “really-like-to”, to set up a Sql
Server 2005 to Sql Server 2005 data posting option over the internet.
Obviously things like security, logins and port numbers come into play but
what I am looking for in terms of advice is best methodology. I’ve looked at
Linked Servers and Service Broker and both seem like they can get the job
done; each with its advantages and disadvantages. I’m more inclined to go
the Service Broker route but at this point it is only a slightly educated
guess. Data volume would not be high and what I am trying to avo
|
2/26/2010 5:49:01 PM
|
2
|
=?Utf-8?B?Uko=?= <...@discussions.microsoft.com>
|
stored procedure or view?
I would like to replace a value in a column provided it meets my conditions.
For instance, if formtype = w123' then set formtype = 'PRO' if formtype =
'w344' then set formtype = 'INT'.
I am fairly new to creating a stored procedure on SQLServer. Do you think
this would require a stored procedure or a view? If either sp or view is ok,
which is less costly to the db? I think that I can apply a case statement in
a stored procedure...but I am not sure how to add this expression in a view.
Thanks in advance!
Thanks
MC
--
Misty :-)
Message posted via SQLMonster.com
http://
|
2/26/2010 3:14:11 PM
|
1
|
"Mitchell_Collen via SQLMonster.com" <u33...@uwe>
|
problem slow queries after installing sp4 on sql 2000
hi, we have a sql server 2000 sp3 on a w2003 and some days ago we installed
sp4 to that sql instance. We are having some big problems with queries really
slow down, taking to much long to complete or locking to themselves, ie. spid
105 locked by spid 105 if you throw a sp_who2.
i've read that this was a common problem with sp4, so, is there any way to
solve this? some hotfix that i don't know or something? i wouldn't like to
detach databases, install sql server again, and reatach all databases....
thanks for any help!
|
2/26/2010 12:21:01 AM
|
2
|
=?Utf-8?B?aU5ld2JpZQ==?= <iNew...@discussions.microsoft.com>
|
Row Versioning
I'm looking at tables that have both high insert/update activity and high
select activity and according to some information, are frequently getting
page level locks when being modified. This is increasing the time the
selects are taking.
To address this I'm considering either Row Versioning Snapshots, or
disabling page level locking.
Any whitepapers out there?
|
2/25/2010 9:04:09 PM
|
9
|
"Jay" <s...@nospam.org>
|
Linking/attaching access tables
Hi
Is it possible to link access tables to a sql server 2005 db? I can't seem
to find any option in Management Studio.
Thanks
Regards
|
2/25/2010 8:55:06 PM
|
1
|
"John" <i...@nospam.infovis.co.uk>
|
Index support for PK/FK
Finding that SQL Server automatically created an index for a PK was no
surprise, in fact, it was expected - how else can uniqueness be enforced in
a system that only provides b-tree indexes.
However, finding that a FK does NOT get an index by default and that it must
be explicitly created was a huge surprise.
Why is this?
|
2/25/2010 8:30:39 PM
|
4
|
"Jay" <s...@nospam.org>
|
sql server agent won't start
hi guys
After I moved my sysdatabases and error log to another drive, I
restarted the sql server services. The databases look fine but sql
server agent won't start.
In the error log/windows event log, there's no error message except
saying "sql server agent shut down successfully" sth like that. I
checked all the data/log/errorlog folder/files permissions and made
sure sql server service account (also sql server agent account) have
all the permissions but still sql server agent won't start.
But then I tried to add that account in the local administrator group
on the server and
|
2/25/2010 7:59:15 PM
|
1
|
mirthcyy <mirth...@gmail.com>
|
Disappearing Databases?
Has anyone ever seen the datafiles for a database just disappear? I saw this
on my development box the other day and just thought I messed something up.
Now, I see it again on another box. In MSS Mgmt Studio I see the icon for
the database in question, but it will not expand. I goto to look for the
data and log files and they are gone. I do know that this server ran out of
space the other day, but that should just prevent the log from growing.
Besides, while the database is active I wouldn't be able to delete the files
for it. I would need to detach the database first.
|
2/25/2010 7:35:01 PM
|
3
|
=?Utf-8?B?bWljaGFlbA==?= <mich...@discussions.microsoft.com>
|
SQL can't calculate!
Please someone tell me this is possible! I am trying to get the
correct calculation from a very simple division: 630/60 which is
10.5. SQL 2008 only displays 10.0. I tried every which way I can
think of. Here is all my code:
select 630/60 -- should be 10.5
select CAST( 630/60 AS decimal(10,2)) -- should be 10.5
select CONVERT(decimal(10,2), 630/60) -- should be 10.5
select CONVERT(float, 630/60) -- should be 10.5
select CONVERT(numeric(10,2), 630/60) -- should be 10.5
select CONVERT(money, 630/60) -- should be 10.5
I even tried using ROUND but still the same. On my computer
|
2/25/2010 4:47:29 PM
|
3
|
GiJeet <gij...@yahoo.com>
|
Can you restore a backup from newer version of SQL Server to older version, if in compatibility mode?
Can you restore a backup from newer version of SQL Server to older
version if in compatbility mode?
i.e. there is a db on SQL2005 running in SQL2000 compatibility mode.
Can you restore a backup of this db onto SQL 2000?
I'm pretty sure the answer is no - I just want an authoratitive
answer.
Cheers,
James
|
2/25/2010 4:35:11 PM
|
2
|
JimLad <jamesdbi...@yahoo.co.uk>
|