dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss in the microsoft.public.sqlserver.server forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.server Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Can anyone confirm a) UPDATE STATISTICS Tablename WITH FILL SCAN will not cause any locking on the table or block other SQL statements b) Both...
css
07-17-2009 02:27 PM
Andrew J. Kelly Go to last post
3 31
I need to archive some financial databases for historical purposes in case in the future we need to look at them again. What type of file should I...
Lee Borio
07-17-2009 02:04 PM
Lee Borio Go to last post
4 35
I have a couple of queries that work but i know are not efficient, could someone help me eliminate the sub selects and get it done without...
Dave
07-17-2009 02:00 PM
Russell Fields Go to last post
5 29
i have query running on local server now planning to create linked server and run the query from same local server but reading data from read only...
sacgar
07-17-2009 10:00 AM
John Bell Go to last post
4 35
Hi Experts, I am new in this area and no nothing abt replication so.. i need your advise pls. we need to setup replication between 2 server. Our...
vinu
07-17-2009 09:58 AM
Ekrem Önsoy Go to last post
7 55
My (simple) query (below) takes (on average) 25 seconds to execute until I add "option (MAXDOP 1)" at which point it takes just 2 seconds. Can...
Dick
07-17-2009 09:20 AM
TheSQLGuru Go to last post
6 72
Hello We maintain a system, which we backup by copying the *.mdf file (sql server some unknown older version). The idea has been so far, that...
jodleren
07-17-2009 07:54 AM
Andrew J. Kelly Go to last post
1 52
Can I restore (overwrite/on top of) a database that is currently a subscriber to a publisher? Meaning, that if my publisher goes down, I would like...
Erik G
07-17-2009 07:15 AM
Linchi Shea Go to last post
1 40
---------------------------------------------- LOCK TYPES 1) Shared Locks (used reading data, compatiable with other shared or update locks) 2)...
Scott
07-17-2009 05:29 AM
Scott Go to last post
5 55
Hi, if I have a table with many fields, but I know that the value that is inside some field is "2.84", how can I do a SQL that will check all...
Paulo
07-17-2009 02:11 AM
Subramanian Go to last post
3 32
INSERT INTO USERS ( , , , , , SELECT
saiprasad
07-17-2009 12:12 AM
saiprasad via SQLMonster.com Go to last post
4 28
I am trying to get ready for my 70-431 test and am really confused on Raid levels. I know what they are but I am using different books and tests...
tshad
07-16-2009 04:28 PM
tshad Go to last post
7 40
I have a very unusual database schema that has been migrated to SQL Server 2005 from Oracle. My forward advisement is the actual schema can not...
Jay Douglas
07-16-2009 04:05 PM
Jay Douglas Go to last post
5 37
Hi, I was just given the old server. It has Windows 2003 Server 64bit and SQL 2000. I know that you can install SQL 2000 32bit or 64bit on Windows...
tolcis
07-16-2009 04:00 PM
Erland Sommarskog Go to last post
5 42
Hi, I have some problems with my MSSQL 2005 Mgmt Studio. I am not able to add new maintenance plans. when I try to add a maintenance plan an error...
Sven W.
07-16-2009 03:40 PM
Ekrem Önsoy Go to last post
1 29
To install mssql 2008 on a windows 2008 server, does windows 2008 need to be 64bit or will it install on the 32bit version of windows 2008...
Raul
07-16-2009 03:39 PM
Ekrem nsoy Go to last post
2 32
Hi all, I'm hoping that someone could help me here. A couple of people at my company has mentioned that we can't purchase a processor license for...
Simon
07-16-2009 02:11 PM
John Go to last post
4 34
Is there any difference between SELECT (MyVal1 + MyVal2) AS SumMyVals FROM MyTable GROUP BY MyVal1, MyVal2 and SELECT SUM (MyVal1 + MyVal2) AS...
Edward
07-16-2009 08:57 AM
Edward Go to last post
5 49
hi - am a newbie - under gun by security chief and so being brief - have a server with backupexec software installed on it and ( somehow ) "a bit"...
Riley
07-16-2009 08:21 AM
Riley Go to last post
2 49
I'm new to SQL 2008 but have been reading about a new feature where policies can be defined and enabled. Is there a way within this feature to check...
tom
07-16-2009 07:50 AM
Scott Morris Go to last post
1 41
Hi, There is an application that no longer supports SQL Server 2000 anymore. The vendor asks us to upgrade the database to SQL Server 2005...
Patrick
07-16-2009 05:00 AM
Patrick Go to last post
3 45
Hi all, I have a SSIS package that is fetching data from an Oracle db into a SQL-Srvr 2005 db. The package runs fine on my local. But when i put the...
Mounilk
07-16-2009 03:49 AM
John Bell Go to last post
1 39
Hi, I am trying to get Service Management mail escalations working with SQL Mail - but keep getting errors when I try and execute the...
Neil Palmer
07-15-2009 03:17 PM
John Bell Go to last post
1 38
Does anyone know how to script out a complete job definition (job creation script) from a T-SQL query? In SQL Server Managment Studio, you can...
josephs
07-15-2009 02:29 PM
Doug Lubey of Louisiana Go to last post
18 114
Hi We would be switching some of our databases to sql server 2008 from sql server (2005 and 2000). What are the training cources I should be...
db
07-15-2009 01:32 PM
db Go to last post
2 48
We just upgraded from SQL Server 2000 to SQL 2005. We used a number of queries in SQL 2000 that used syntax like the sample query below where "abc"...
Demian
07-15-2009 11:43 AM
Demian Go to last post
3 32
I have a new client running SBS 2003 Std (no SA) with SQL 2000 purchased separately. Their server HW warranty is about to expire so we are looking...
Diane
07-15-2009 09:25 AM
Diane Go to last post
2 46
SQL Server 2008, SP1 My user is trying to do a bulk insert from a bunch of text files containing the raw data after several hours the process...
Blake
07-15-2009 09:15 AM
Blake Go to last post
3 116
Hi I have a new database (in 2005) WITH data (as opposed to what I posted previously) that I want to convert to 2000. Any suggestions how to go...
Samuel
07-15-2009 09:01 AM
css Go to last post
1 33
Hi all Can anyone give me a starting point on how to acheive this: I have two tables Table 1: Id VehicleName VehicleSpec
James Page
07-15-2009 08:16 AM
James Page Go to last post
6 39
We have sqlserver 2005. I need to find a method that I can automate to change a stored procedure and a function name, the issue is that I can not...
Horacio Filet
07-15-2009 07:22 AM
John Bell Go to last post
4 30
I have a table in the Master db in SQL Server Express and I would like to transfer this table into another Database. Below is the code I am...
Brian Conner via SQLMonster.com
07-15-2009 05:39 AM
John Bell Go to last post
5 72
Hi I running SQL2K SP4 at Win2003 OS I have one database backup file backup.bak having database file abc.mdf 60GB and Transaction log abc.log 1GB...
gbkhor
07-15-2009 05:38 AM
gbkhor Go to last post
4 79
D/L it (just for the sake of it) and went through the install on this dev box. Got through it and to the bit where it says to select/unselect all. 2...
Jack
07-15-2009 04:47 AM
John Bell Go to last post
9 59
Hi, we use SharePoint 2007 SP1 with SQL 2005 SP3. The databases at the moment are about 850MB, but the config Log file is about 41GB ! For backup we...
Juergen N.
07-15-2009 01:57 AM
Juergen N. Go to last post
4 58
I am new to SQL server 2005. If there are many nested if conditions, it becomes difficult to map the begin and corresponding end tags of each...
pacman
07-14-2009 10:14 PM
Jeff Doak Go to last post
6 100
I added a "Q:" drive to the SS2008 server but the instance does not appear to recognize it yet. Do I have to bounce the instance in order for it to...
Snake
07-14-2009 09:49 PM
Jeffrey Williams Go to last post
3 27
I just noticed today that my MOM/ForeFront server wasn't working anymore, so I've worked backwards and I notice now that SQL cannot open the...
Andrew Weaver
07-14-2009 05:41 PM
Erland Sommarskog Go to last post
18 91
i know about index defrag and performance but has anyone had experience with a filesystem defrag and SQL performance? I would imagine that if files...
Dan Holmes
07-14-2009 10:05 AM
Linchi Shea Go to last post
3 38
i have a problem in which i cant add full text index. what i see is like in this print screen...
peleg
07-14-2009 08:21 AM
Russell Fields Go to last post
6 48
It seems the C:\windows\installer files from previous SQL server installs were deleted. Thus when I attempt to upgrade to SQL Server 2005 SP3,...
minfald
07-14-2009 04:03 AM
Manpreet Singh Go to last post
2 36
Is this enabled by default with 2008? I notice that each DB created has this enabled... inc DBs such as ReportServer. Is this using up resources if...
Jack
07-14-2009 03:18 AM
Jack Go to last post
3 40
I have requirement to store a set of messages in SQL Server 2005 within a fixed time period. I ran a process which executes various SP's for 24h...
itatai
07-13-2009 09:21 PM
Jeffrey Williams Go to last post
6 50
When I attempt to schedule a maintenance plan, i receive the following error: unhandled exception has occurred in a component in your...
minfald
07-13-2009 08:54 PM
Linchi Shea Go to last post
2 45
I installed SQL Server 2008 under a VMware Windows 2008 Server. When I went to add the Administrators group to the logins under SQL Server, I get a...
Steve
07-13-2009 03:17 PM
John Bell Go to last post
4 53
I don't know if what I want to do is possible (other than building a whole sql string and then executing that), but thought I would at least ask as...
Gerhard
07-13-2009 12:08 PM
Gerhard Go to last post
2 60
hi all , i want encrypt and decrypt the numeric value ? is it possible ? below example only working for varchar value used XOR Function and also...
Ramesh Subramaniyan
07-13-2009 09:44 AM
John Bell Go to last post
3 47
Hi I have a new database (in 2005) WITH data (as opposed to what I posted previously) that I want to convert to 2000. Any suggestions how to go...
Samuel
07-13-2009 08:57 AM
Plamen Ratchev Go to last post
1 49
SQL Server 2000 SP4 Standard I am trying to run an update (which usually takes about 10 seconds) is taking 20 minutes. I am certain indexes and...
css
07-13-2009 08:56 AM
Russell Fields Go to last post
4 39
Hi. I'm looking for a bit of advice as to when one ought to create a new instance instead of continuing to add new databases to an existing...
YaHozna
07-13-2009 08:52 AM
YaHozna Go to last post
2 35
Post New Thread

Display Options
Showing threads 2201 to 2250 of 48667
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.