Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum

Tip: Looking for answers? Try searching our database.

DB Engine

Recently updated threads


Thread preview

SQL Server (view all ...)Last Post  Replies
Locating Invalid rows after restoring S2K db to S2K8 (DBCC error 214 Mar 2010 08:37 GMT2
After doing a restore to migrate a SQL 2000 database to SQL 2008 we ran the
DBCC CHECKDB DATA_PURITY command which identified Invalid Rows in several
tables.
The data type of many of the identified columns was numeric(16,2), and we
Query on multiple servers, sort by server name13 Mar 2010 23:03 GMT10
I'm running a query on the sysjobhistory table on multiple servers. This
works fine, except that the results are not sorted by server name, which is
quite annoying. As the column "server name" is not part of the query, is
there a way to sort by this column ?
Long execution time for UPDATE tbl SET @var = col = {expression} under SQL200013 Mar 2010 18:29 GMT5
Folks:
We have SP queries like:
 UPDATE tbl
 SET @var = col = col + 1
JTDS support for shared memory access12 Mar 2010 19:34 GMT1
Can anyone tell me if JTDS supports shared memory access?
I would like to access the DB with TCP and Named Pipe DISABLED
Appreciate your replies. Thanks
From http://www.developmentnow.com/g/118_0_0_0_0_0/microsoft-public-sqlserver-server.ht
Primary Key - string or integer12 Mar 2010 14:28 GMT7
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).
Default Degree of Parallelism on SQL Server 200512 Mar 2010 14:24 GMT13
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.
how do i stop a maintenance plan?12 Mar 2010 14:22 GMT7
I have a maintenance plan that runs every night.  Sometimes it takes too long to run and it affects production for the
following morning.  I can see and kill the process it is currently running but then the next task starts and i have to
kill that too.  How can i stop the thing ...
SRID values for Spatial Data Tyoes in SQL Server 200811 Mar 2010 22:19 GMT1
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

MSDE (view all ...)Last Post  Replies
Can SharePoint_Config_cc0ad..1_log.dbf in MSSQL folder be reduced?01 Mar 2010 15:55 GMT-
Is there a way to reduce the size of log.LDF file below.  We use Windows
SharePoint Services 3.0 installed on Server 2003 R2 Standard.  Used on a very
small scale.  I am running out of space on Drive C, and I notice that log.LDF
file is almost 10 GB.  The file increases about 1 ...
Accessing MSDE from Windows 7 across the network01 Mar 2010 06:55 GMT-
I'm trying to, but can't, access a MSDE (SQL server express) on a labtop
that it running Windows Vista Home 32-bit (SP2).  The machine I'm trying
to access it from is running Windows 7 64-bit.
Is this a know issue?  Do I need to setup something to make it work?
DESCARGAS - ANTIVIRUS GRATIS 764117 Feb 2010 18:28 GMT-
Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:
SQL Server 2005 express configuration Checker can't execute #214 Feb 2010 02:27 GMT-
I just tried to turn on the Windows Managment Instrumentation module in
management services and it said the module cannot be found.  How can I find
and install this Windows Management Instrument in Services?  I was able to
start the windows managment driver.
SQLServer2005express  Configuration Checker can't execute14 Feb 2010 01:42 GMT-
I installed SQL Server Express 2005 on Windows XP home with 512 mb memory but
when I click setup.exe I get this error.
The error is "The SQL Server System Configuration Checker cannot be executed
due to WMI configuration on the machine, myMachine Error:2147942526
SQLExpress 2005?26 Jan 2010 01:50 GMT2
Greeting All,
I really need some help. I have 400+ Vista workstations running SQLExpress
2005. Due to a recent change in business; I need to modify a single stored
procedure on each unit. Is it possible to script this change; if yes, how?
MSDE install19 Jan 2010 16:48 GMT2
Can MSDE install on windows 7
Pls advise
Michael
sql express in parallel with MSDE06 Jan 2010 15:21 GMT1
I have an SBS 2003 R2 box with 1 default SQL MSDE instance and 3 named SQL
MSDE instances. We are considering installing Blackberry Professional Server
Express Edition, which requires SQL Express 2005. Is it possible to install a
single named instance of SQL Express 2005 in ...

SQL Server CE (view all ...)Last Post  Replies
Access with ActiveSync to SDF database14 Mar 2010 11:21 GMT1
i need to access to SDF database on Device from an application Desktop with
activesync. i did search but i didin't a applicable solution still.
Suggests?
Compact 3.5 Primary Key04 Mar 2010 18:22 GMT1
I am trying to create a new Compact 3.5 database & tables in code so that my
user can create a new DB on the fly without my help. The problem is that I
cannot create 2 columns in the same table as a Primary Key pair this way.  
When I define the table or alter it using the SQL ...
杀毒软件免费下载 988302 Mar 2010 11:16 GMT-
许多性能问题和您的计算机安全造成 恶意病毒,最好的办法对付,这是要安装 防病毒确认和您的计算机上更新
杀毒软件免费下载:
http://antivirusfreecn.blogspot.com/
链接网站的内容:
Sharing SQLCE Database26 Feb 2010 19:41 GMT5
I have a scenario where I have a Windows CE 5.0 device that will be used as
a small server in a industrial equipment.
The clients will use a SilverLight application (already hosted in the CE
device, what is already working).
ANTIVIRUS FREE DOWNLOAD 892426 Feb 2010 00:04 GMT-
Many problems with performance and safety of your computer can be solved
easily with an updated antivirus and recognized. Antivirus Free Download
Microsoft best practices in:
http://yourantivirusfreedownloadonthissite.blogspot.com/
Transcript of Windows Embedded CE Live Chat - February 201024 Feb 2010 12:19 GMT-
Did you miss the Windows Embedded CE Live Chat yesterday?
Don't worry! We've put the transcript here
http://discovertheexperience.blogspot.com/2010/02/windows-ce-live-chat-transcrip
t-februar.html

Have fun reading!
CE 4.2023 Feb 2010 03:02 GMT1
i use windows ce 4.20 and sqlserver ce 3.5. When i test my program (vs 2008
and framework 2.0), i get an error  on SqlCeCommand.ExecuteReader :
A native exception has occured in... Select quit and then restart this
program, or select details for more information.
how to get the last value19 Feb 2010 08:57 GMT1
the functions first or TOP are not working with CE.
I have a table with a structure: Id integer, weight single, MadeOn datetime.
In this table the weights of persons are saved. Now I would like to get all
persons
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.