Sponsored Links

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Page 16 of 283

« First

116

Last »

Threads in Forum : comp.databases.ms-sqlserver

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Question about restore database and create new filegroups I posted several hours ago, but did not see it. So I post it again. Recently, I am moving a database from one server to another server due to the... Lee	04-30-2009 02:05 AM Erland Sommarskog	1	130
Query Performance Thanks to everyone for the feedback. I get what you are saying about adding the filter to the WHERE clause negating the LEFT JOIN. What I can't... Eric	04-29-2009 02:39 AM Erland Sommarskog	6	127
Question about restore database and create new filegroups Recently, I am moving a database from one server to another server due to the storage issue. The existing database is about 30G, all tables are in... Lee	04-28-2009 08:12 PM Lee	0	126
Mung personal data I've taken over support of a small database and the client has given me a copy of the data. It contains moderately sensitive information (real... teddysnips@hotmail.com	04-28-2009 05:06 AM teddysnips@hotmail.com	5	111
Best Score Query Problem I am working with a database that tracks sector scores for economic data. There are five sectors that are scored for geography entities. A scoring... DannyDarko	04-26-2009 08:32 PM Plamen Ratchev	5	132
Stored Procedure Wizard Is there a wizard that can create update, insert and delete stored procedures for chosen Tables? E.g. creates parameters for all columns and includes... Russ Sherlock	04-25-2009 02:35 PM Philipp Post	1	125
Execution Plan: How to read and interpret Does anyone have a link to a basic overview of execution plans? I've looked in BOL, but must be looking in the wrong place, because I can't find... bill	04-25-2009 04:36 AM Erland Sommarskog	2	117
Transactional Replication Large Database (also posted on microsoft.public.sqlserver.replication, but low traffic) Hi, Sql Server 2005 I am not a replication expert but have set it up a few... xAvailx	04-24-2009 10:19 AM xAvailx	0	127
question about disaster recovery ala virtualization I'm thinking about disaster recovery in the context of virtualization. I have a virtual machine (call it VMWare ESX if it matters) on a host. The VM... aj	04-24-2009 08:24 AM Greg D. Moore \(Strider\)	2	217
Can I use Select Case? Hi, I'm trying to change the field PM.TRANSQTY to '0' if the field pm.ADDCOST is '3'. I can change the field PM.ADDCOST to '0' but is there also a... wibni	04-23-2009 01:25 AM wibni	2	106
general design issue hi, i'm not sure if this group is NTG for my question, and if so i'm really sorry... i don't know much about SQL - just basics: tables, indexes,... skink	04-22-2009 07:11 AM Philipp Post	3	126
SQL 2008 AD Group permissions I have set up a new SQL 2008 server. I am trying to grant permissions for users via Windows Authentication. I have created a group in AD and I put... gsauns	04-21-2009 10:18 AM gsauns	1	109
paging, I know theres loads of articles on this but... Hi I've read a great many articles on paging and the ways you can do this in Oracle and MS-SQL. I just want to understand one particular point more... codefragment@googlemail.com	04-20-2009 06:34 AM codefragment@googlemail.com	2	123
Moving from 2000 to 2008 has anyone attempted to move databases from SQL2000 to SQL2008 ? any tips for me? John A. Shiells	04-17-2009 03:52 PM Plamen Ratchev	2	116
Select Distinct Days and Count for each day I have a table with a list of 'hits' in it. Each record is a unique datetime, with some other info. I need to run a quick query to get all of the... erupnu	04-17-2009 10:57 AM erupnu	2	126
What is LOP_SHRINK_NOOP ( 1 2 ) Hi all, Can anyone explain what the LOP_SHRINK_NOOP is in the transaction log? My SQL Server 2000 database is set to FULL recovery model... Thomas Yan	04-16-2009 06:39 AM Thomas Yan	10	403
Can't open tables from object explorer using ssms (SS 2005) I have a very weird problem. I log into a SQL Server 2005 remote server using SSMS. I navigate to a database that I have access to and expand down... Crazy Cat	04-15-2009 09:38 PM Crazy Cat	1	246
multiple variables set from one row I have a stored procedure where I assign values to multiple local variables from the same table row -- e.g.: set @var1 = (select a from table1 where... Neil	04-15-2009 11:51 AM Neil	2	123
ODBC / mssql very slow Hi group, In my current project I have a performance problem. I hope somebody can help with it. - MSSQL 2005 server - PHP5/IIS running over ADOBD... Erwin Moller	04-15-2009 08:30 AM Erwin Moller	0	112
UNPIVOT to result with multiple columns I need some help using UNPIVOT. I can do basic UNPIVOTs, but am having trouble with ones of a little more complexity. If someone can come up... bill	04-14-2009 10:00 PM Plamen Ratchev	7	143
Triggers with Linked Servers and Linked Server Test Good Morning Everyone I developed a trigger that alters a table on a linked server (that is working just fine) everytime that the local table is... Paulodemoc	04-14-2009 06:52 AM Paulodemoc	0	114
problem installing sql server 2000 enterprise manager After uninstalling SQL Server 7 Enterprise Manager I wanted to install the 2000 version of Enterprise Manager (not the server!). After inserting the... ab	04-14-2009 06:23 AM ab	3	125
Installing SQL Plz advise SQL on XP,,,,,,,,,,,,which product is Good means SQL which version? thanksssss rashid.imtiaz@gmail.com	04-13-2009 09:06 AM Plamen Ratchev	1	160
Help needed to complete this query. Hi , I need help for below query. We have one EmpDetail table which is storing employoee personal informations. There is one coulmn "LanguageID" in... Dinesh	04-11-2009 10:43 PM bill	4	145
SSRS 2005 - two questions about parameters Hi. In database I have structure of Word files in different tables (paragraphs, hyperlinks, pictures etc). I've got a problem, when I want to create... lszk	04-10-2009 10:48 AM lszk	2	121
DTSRun causes The Memory could not be "read" application error Hi, I've got this dts package in sql server 2000 sp4 that has several transformation tasks with an oracle database (10g) as the destination. The... lyn.duong@gmail.com	04-10-2009 10:46 AM JB	3	268
Reverse "LIKE" sql statement Hi every one, If I wanna fetch a db entry how got "blue car" in a field, 1 > I can set "WHERE fieldName LIKE '%blue%' " 2 > But how could I make the... sylvainhugues	04-10-2009 09:42 AM Michael Austin	7	135
MS-DTC Selection among SQL 2005 Instances on Windows 2008 Cluster Some background: - 2 nodes Windows 2008 (with SP1) Cluster - SQL 2005 (With SP2) cluster - 3 named instances. No default instance - 4 instances of... bavien@gmail.com	04-09-2009 11:50 PM bavien@gmail.com	0	120
t-SQL Partitioning Hi, I've got a table of currency rates that stores the average currency rate for each currency for past months and years. The columns of my table... Eric	04-09-2009 10:46 AM Plamen Ratchev	1	123
How to use SetServerVersion() in SMO scripting. I need to "downgrade" a DB that is running in SQL 2008 for SQL 2005. Long story. In SQL 2008 Mgmt Studio there is a compatibility option you can... Raz	04-09-2009 07:46 AM Plamen Ratchev	1	112
Expanding databases continues indefinitely I ran the following query from a Microsoft Press book: USE tempdb; IF OBJECT_ID('dbo.EmpYearOrders', 'U') IS NOT NULL DROP TABLE... tharpa	04-07-2009 10:11 PM Greg D. Moore \(Strider\)	2	105
PIVOT Hi, I have a table "GeneralInfo" like this: KeyID SettingsKey ... Radu	04-07-2009 12:49 PM Plamen Ratchev	5	150
Change the default of a column Here's a simple question, but I just can't get it working. I want to change a column's default. For example, I have a Table, T_Names, with a field,... Dom	04-06-2009 10:16 AM Dom	2	185
Saving an export package in Sql2008 We are upgrading to SqlServer2008 and I'm starting to build packages. I built a package with the export wizard. At the final stage I'm asked whether... David Greenberg	04-06-2009 06:44 AM Plamen Ratchev	1	143
register hight cost querys Hi, Is possible to log querys wich takes a long time to run. Since 2 days my server slows down with no explanation for 15-20 second after that all... danielpila@gmail.com	04-06-2009 01:00 AM danielpila@gmail.com	2	117
Scrip to make a job backup for SQL server 2005 hi guys i would like to know if anybody has a scrip to make a job backup for sql server 2005, i need to make a fresh install.. and the jobs backup... Hansel Ortiz -[BrEcHaWarr]	04-05-2009 11:50 PM Ed Murphy	2	218
eliminate duplicate in JOIN The following query will return Triple word from a table like the following: pretty, woman, a a, pretty woman china,great, wall wall, great,... Carl Forsman	04-05-2009 09:27 PM Plamen Ratchev	4	132
Returning a 'uniquely unique' set of rows. ( 1 2 ) Hi, I'm using SQL Server 2005 and I want to write a stored procedure or UDF that will return x number of rows to the calling client (an... A. User	04-05-2009 01:22 PM Michael Austin	12	235
Re: change auth_mode It is in the registry, two examples of changing... Plamen Ratchev	04-04-2009 09:43 AM Jaroslaw Kozik	1	217
Script to make a jobs backup in SQL server 2005 hi guys i would like to know if anybody has a scrip to make a job backup for sql server 2005, i need to make a fresh install.. and the jobs backup... Hansel Ortiz -[BrEcHaWarr]	04-04-2009 09:10 AM Plamen Ratchev	1	121
Re: Writing NUL (00) instead of NULL -- suddenly! You can use sp_refreshview to update the metadata for the view. Could be that there have been some changes to underlying objects. -- Plamen... Plamen Ratchev	04-04-2009 09:06 AM Plamen Ratchev	0	141
Select Primary Key of Highest Record in each Group? Ok... This was harder than I thought. The following query will get the "thing" from the row with the highest iVersion. SELECT vchThing,... HumanJHawkins	04-04-2009 05:53 AM PDreyer	5	158
Re: sql-query This is best done in reporting interface that supports pivoting. To accomplish this in T-SQL you can use a calendar table and dynamic pivoting... Plamen Ratchev	04-03-2009 08:22 AM Philipp Post	2	146
Multiple Rows in to One Row Hi, I have a table like the following: COLUMN1 \| COLUMN2 ------------------------------------ 20 \| 123 20 \| 985 23 ... ninadunn@gmail.com	04-02-2009 04:43 PM steve11228@gmail.com	5	159
Invisible Trigger? Or maybe it rode off into the sunset? I'm using SQL Server Management Studio 2005 to connect to a remote SQL Server 2005 database. Works fine, with... Piet Linden	04-02-2009 09:02 AM Piet Linden	2	141
Best way to index 16 million time/location rows for searching? Hi there, I have only recently started using MS SQL server having made some fairly complicated databases in MS Access but nothing with nearly as... news.virginmedia.com	03-30-2009 12:50 PM James Riches	6	150
sql 2005 job agent issue Hello, Our SQL 2005 server is installed in 2k3 64bit windows. I installed 32bit odbc driver into the system, but when I tried to run agent job, it is... Phillip	03-27-2009 04:32 PM Phillip	0	131
Repeated Login failed for user 'sa' Sql Server 2000 I know that there are many postings about this but many blame it on hacker attacks. In this case, we have a SQL Server that is... Bill E.	03-27-2009 10:22 AM Bill E.	0	119
SQL 2000 Agent running but not working Error 14258 on job access We have MS SQL Server 2000 running on a cluster. The SQL Agent shows as running but no jobs are being ran as scheduled as of this... Mark D Powell	03-27-2009 07:51 AM Mark D Powell	1	139
Select Highest Values Within Each Group? I have a table with non-unique things in one coilumn, and a version number for those things in another column. I am trying to SELECT the latest... HumanJHawkins	03-26-2009 11:20 AM HumanJHawkins	1	115

Page 16 of 283

« First

116

Last »

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