Sponsored Links

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

Page 7 of 1157

Threads in Forum : microsoft.public.sqlserver.server

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
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... Mikael Sorensen	08-31-2010 04:35 PM Erland Sommarskog	9	103
Overwrite Master Db Hi all, I have a question about Master db in a DR environment. Our customer has follow environment setup: Live Site: SQL Server 2008 Standard DR... Tao	08-31-2010 02:34 PM John Bell	1	27
Linked Servers I would like to create two linked servers to the same data source. The first linked server has fairly open access to the database. The second... LisaM	08-31-2010 10:54 AM LisaM	2	28
SQLServer Error: 802, 701, 733 ( 1 2 ) SQL Server 2008 on Win2008 R2 x64 Server, 8 GB RAM - running virtualized on VMWare ES-Server Every sunday some maintainance jobs are scheduled to... Bernd Maierhofer	08-30-2010 10:37 AM Bernd Maierhofer	18	31
Shrink transsaction log file I try to shrink the transaction log file. I made a back-up of transaction log and after that from context menu->Tasks->Shrink->Files->Transaction... Nick Brad	08-30-2010 06:22 AM Nick Brad	3	24
laying out iscsi drives for SQL Is there a best practice for laying out a disk structure on a Windows Target server for an SQL server initiator's drives? Point being, when... fros	08-29-2010 04:40 PM fros	0	22
drop database [using parameters] Hi guys can someone tell me what is wrong with this procedure. =============== set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go revealer	08-29-2010 10:36 AM revealer	2	22
sql 2008 data compression We are thinking of running compression on our databases now that we moved over to SQL 2008 ? Our databases are quite huge and was wondering, how... Raj	08-28-2010 07:49 AM Jeffrey Aven	2	25
Create trigger Hii, Can any one please let me know the process that how can we create trigger so that it grab the job failure logs when the job fails and that... Kareem via SQLMonster.com	08-27-2010 02:28 AM Erland Sommarskog	5	23
convert(binary(4), @Number) not giving expected result Hi I thought the following code would give me a result of 1101 bit instead it gave me 0x00000000D. declare @Number int set @Number = 13 select... Brian	08-27-2010 02:04 AM Jeroen Mostert	5	28
Multiple backups with datetime stamp I want to backup multiple Databases on Daily biases and create a file for each Database. I would like the backups to have datetime stamp. I was... jah1	08-26-2010 11:25 PM SteveF	1	18
Auditss in SQL server 2008 ( 1 2 ) 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... sleeba	08-26-2010 11:16 PM SteveF	14	65
Mutually Exclusive Set Comparisons ( 1 2 ) Hi there, I've been toying around with a problem for months and have had little success in answering it; mostly because my limited ability to... Flam_B	08-26-2010 11:04 PM Flam_B via SQLMonster.com	13	39
Transactional replication of VLDBs Hi Folks, I am assigned to do a transactional replication of a large database of size more than 4 TB and As the snapshot cannot hold the large... SQL Hunter	08-26-2010 04:26 PM Erland Sommarskog	1	23
the incoming tabular data stream remote procedure call is incorrec Hello, I am using SQL Server 2008 Express with sql native client 10.0 as a backend to an Access frontend. When I try to updated one of the linked... M. Wilson	08-26-2010 04:18 PM Erland Sommarskog	3	29
Inherited column collation Hi, Just to clarify, my understanding is that all column collations are hardcoded and there is no inheritance structure. Is this correct, or does... JimLad	08-26-2010 03:27 PM Sylvain Lafontaine	8	20
File/Filegroup last changed Is there any way to tell when the last time data in a file or filegroup has changed? BLilly	08-26-2010 08:51 AM BLilly	2	26
Query execution plan problem Hi, I have encountered a problem with a query execution plan on MS SQL Server 2008. It is a simple query on a single table. The table has a primary... Bozena	08-26-2010 05:37 AM Erland Sommarskog	7	18
MSDB database more large after "Clean up history" Hi, I've a problem with system database msdb size, because after I run the maintenance plans " Clean up history" for delete all history < 1 month,... Massimiliano	08-26-2010 02:28 AM Massimiliano	0	21
How to use datepart in below scenario Hi Guys, I have the following dates: 8/23/2010 6:30:00 AM 8/24/2010 6:29:00 AM 8/25/2010 7:00:00 AM 8/26/2010 5:00:00 AM 8/23/2010 6:30:00 AM/ is... george_faz via SQLMonster.com	08-25-2010 08:20 PM george_faz via SQLMonster.com	3	20
Auto increment int field in select statement What I am trying to figure out how to do is to have a int to start at 1, 2, 3, ect. But I want then counter to reset when the... TheVillageCodingIdiot	08-25-2010 01:56 PM TheVillageCodingIdiot	1	23
Re: Create Clustered Index on View Problem RobJones (u63709@uwe) writes: Presumably there is a hickup with the query plan to run the query itself; it does not have anything to do with the... Erland Sommarskog	08-25-2010 10:03 AM Erland Sommarskog	2	25
one-to-one relationships in a database diagram ( 1 2 ) hello, I am trying to figure out how to draw a 1:1 relationship in a database diagram (or with foreign keys) from visual studio 2005. in the books... Andy Fish	08-25-2010 04:21 AM Joshua Klein	11	64
create View showing a conditional field How can I create in a view, a calculated field (name) that depends from other field (value) as follows: if not isnull(value) then (name)... LuisM	08-24-2010 10:19 AM LAM	4	24
Failed to backup Hi, I have SS 2005 9.0.3228 (SP2 ??) this server is a publisher for merge replication every 5 or 10 min there are about 100 subscribers. Is it... bob123	08-23-2010 02:35 PM bob123	1	22
Backup strategy with torn page detection on? I have 2005 and planning to turn on the torn page detection at the database level.. If I do a full backup with Init and checksum on and if sql... Bero	08-23-2010 01:20 PM Erland Sommarskog	1	22
how to pass the result of count(*) in a variable in a SP? Hi, i want to fetch the number of records in this stored procedure and put it into a variable for further test.I get an error on the line containing... Phil	08-23-2010 11:20 AM Phil	2	23
Installing on Win7 My computer is running on Windows 7 with Visual Studio 2008 Sp1 and .Net 3.5 sp1 I am not able to MS SQL 2008 and getting compatibility issue error... Raj	08-23-2010 10:39 AM Raj	2	26
Show int field as fixed lenght field Using a view, I need to fullfill with zeros (0) at the left of whatever number found in a integer field, converting it to a fix lenght of... LAM	08-21-2010 09:11 AM LuisM	4	26
Extract month form a datetime field Hi, something else: I want to show in a view, the month of a date as fixed format = "00" Thanks again LAM LuisM	08-21-2010 07:14 AM Erland Sommarskog	1	18
Appears to be a Service Broker Transmission Queue Send Threshold Hi all I'm using SB to pass messages from one server to another. Data come into the first server as a regular stream of discreet messages, and I... Charles	08-20-2010 05:15 PM Gene Wirchenko	7	17
error while using case statement Hi, I have to modify an existing query as below existing logic: and table.location in (select city from tablename1 where col=col) New logic: Now... cauverypoonacha	08-20-2010 03:54 PM Erland Sommarskog	1	19
partition or archive What is the difference between partitioning a table and archiveing a table in sql server 2008? seeker	08-20-2010 03:09 PM John Bell	1	23
sql 2005 & 2008 standard (32 and 64-bit) evaluation copy Where can I download the evaluation copy (ISO or EXE) of SQL 2005 and 2008 standard (32 and 64-bit)? problem man	08-20-2010 09:27 AM John Bell	4	23
SQL 2005 Best Practices for log files Microsoft says to put data and log files on different physical disks. I have already moved the backup files to a different physical disk; can I use... Rich Lawson	08-20-2010 01:32 AM Gert-Jan Strik	1	28
sql Data Synching Hi, What the the best approch to do the data sunch between 2 sql servers. Production db hierarchy columns value... Mecn	08-19-2010 04:46 PM Mecn	0	21
Locking in SQL 2005 I have an insert table trigger which amongst other things, massages inserted column value. Within this trigger, I am stuck with select and then... RG	08-19-2010 04:19 PM Erland Sommarskog	5	14
Delete all fields in database... I have a sql database on Godaddy.com. I was wondering if there is a way of deleting all the fields in the database using a query? I want copy and... RAB	08-19-2010 04:11 PM Erland Sommarskog	4	17
skip db offline run job backup good day I make a backup via query set to a job, my problem is that when the DB is offline I blocks the execution of the job, how can I change the... Angar	08-19-2010 05:41 AM Erland Sommarskog	3	22
how to prevent simultaneous access to a table? ( 1 2 3 ) Hi, Students can subscribe for any project via a webform. Table 'project ' contains all the proposed project and table 'student' contain the name... Luc	08-19-2010 03:29 AM Luc	23	40
error while using case statement Hi, I have to modify an existing query as below existing logic: and table.location in (select city from tablename1 where col=col) New logic: Now... cauverypoonacha	08-19-2010 02:48 AM cauverypoonacha	0	41
Union... I have 2 tables as follows: Table 1 - Names Name_Id (int) primary key First_Name (vchar) Last_Name (vchar) Address (vchar) City (vchar) State (vchar) RAB	08-18-2010 07:24 PM RAB	2	18
SQL 2005 view vs table execution? When you excute your query a table using via view, does it compilies each time when you query or does it uses any kind of stored data in the memory... Bero	08-18-2010 06:05 PM Bero	0	20
BCP Computed Column Hi. I have a table with a computed column. When I try to import data into table through BCP it generates error due to computed column. So how to... Muhammad Bilal	08-18-2010 05:10 PM Tom Cooper	1	19
Problem with SQL Server Import and Export Wizard in SQL Server 200 We are using SQL Server Import and Export Wizard to export from a view to a flat file. This export worked in under 20 seconds in SQL Server 2005 SP3... LisaM	08-18-2010 04:51 PM Erland Sommarskog	1	15
Restore database error: Microsoft SQL-DMO (ODBC SQLState: 42000) I created a complete backup of a SQL Server 7 database so that I can recreate it on a SQL Server 2000 database. I tried 2 options but got the... malehit@devdex.com	08-18-2010 09:21 AM Mayur	5	150
SQL 2005 Best Practices for backups I have been working on the conversion from SQL 2000 to SQL 2005 for best practices. I have come a long way. I only have 47 issues whcih I... Richard Lawson	08-18-2010 06:37 AM Dan Guzman	2	20
Are there and Built-in Application Failover Technologies in .NET and/or Windows Server 2008 (or SQL Server) Hi all A bit of a general question, hence the cross-posting. I have a .NET application running on a Windows Server 2008 server. For resilience, I... Charles	08-17-2010 06:53 PM Charles	4	16
Changing database collation for existing databases Hi, We are upgrading from SQL2000 to SQL2008R2. We are taking the opportunity to update the collation on our databases. Sorry to bring this up... JimLad	08-17-2010 02:10 PM Erland Sommarskog	3	20
Restoring DB - getting error message instead Hello SQL Monsters I used the backup code below to backup 32GB database and it was a success. However, now I need to restore the database but... Mitchell_Collen via SQLMonster.com	08-17-2010 11:45 AM Mohit K. Gupta	1	17

Page 7 of 1157

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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