Hi everybody, I have a stupid question. I want to improve performance of my SQL Server and I'm wondering, in this case, if this way is possible : 2...

PatriceH

07-23-2009 11:49 AM
John Bell

On a Windows 2008 Enterprise server with 64 GB of memory that dedicate to one SQL Server instance, how much memory SQL Server should use versus...

Lijun Zhang

07-23-2009 10:08 AM
Shephardd

Hi I'm using SQL 2005 on Windows Server 2008 x64. SQL Tools wouldn't install when installing SQL yesterday and I'm wondering if this is why there...

Brian

07-23-2009 09:39 AM
Brian

I was wondering if anyone could shed some like on why the following query kicks out the following error? Msg 242, Level 16, State 3, Line 2 The...

Fieldmedic

07-23-2009 08:16 AM
Fieldmedic

Hi. What should be the fill factor as alot of insert , update and select is done in the database but no deletion is done. so what should be the...

Muhammad Bilal

07-23-2009 06:36 AM
Carlos Sacristan

One of the developers has created a server killer query (15 tables) and placed it into a view. There are severe problems with parallelism, which...

Michael Clifford

07-23-2009 06:33 AM
Dan Guzman

Given a tablename...I was wondering if there is a generic way using INFORMATION_SCHEMA.COLUMNS or something to detect whether a column has...

swegele

07-23-2009 03:04 AM
ms

Hi, all I am trying to share data between different stored procedures in the same connection/session. Stored procedure test1: CREATE PROCEDURE...

Bo Chen

07-23-2009 02:36 AM
Steen Schlüter Persson

Hi all, I have a problem that has puzzled me for quite a long time... How can I tell why SQL Server (as a process) suddenly has a huge demand...

jeff_yao

07-23-2009 02:35 AM
Uri Dimant

Hello all all of a sudden, and on one instance only, Database mail stopped sending mails. I tried all I could find on Internet, no chance. Even...

wpher56

07-23-2009 01:27 AM
wpher56

I am running SQL Duration Statistics in SQL Profiler 2005 to determine what procedures/T-SQL are being fired when submitting an order for...

Glenn

07-22-2009 07:49 PM
Andrew J. Kelly

I am running SQL 2008 SP1, Enterprise on Win 2008. I notice in running an update in a stored procedure with the query execution plan turned on that...

cbrichards

07-22-2009 07:46 PM
Andrew J. Kelly

Hi. SQL Server 2000 EE gives timeout expired error continously when data is loaded in bulk from text files through a application developed in VB 6....

Muhammad Bilal

07-22-2009 05:41 PM
Erland Sommarskog

What encryption is used to store our SQL login passwords in the table? What happens to the clear-text password which we use to create a SQL...

ronnie

07-22-2009 03:25 PM
ronnie

I have a scenerio that I am trying to resolve, I need to be able to run remote stored procedures and SQL Agent Jobs through linked servers....

Bargle

07-22-2009 02:18 PM
Bargle

Guys, Is it possible to disable or prevent Trusted Connection logins to Sql Server Express 2005 installed on a laptop for non-admin accounts using...

Uday

07-22-2009 01:30 PM
Uday

Hi all, I am tasked with a general problem to come up with scenarios and possible preventive measures to take for the database of our product. Our...

Uday

07-22-2009 11:21 AM
Uday

Hi I have VS 2008 that has an SQL server 2005 developer disk with it. I am setting up a small network with 3 computers and was wondering if this...

svt4cobra6

07-22-2009 09:54 AM
svt4cobra6

Not sure if I should post this in this board or an MS Access one. I have an access database with a query called qrySelectAccNum with three...

Chuck W

07-22-2009 09:39 AM
Lucas Kartawidjaja

I have a DB that unexpectedly grew from 245 GB to almost 340 GB (90 GB growth) in a day and I haven't been able to figure out what caused it....

Carlos

07-22-2009 09:08 AM
TheSQLGuru

We have 30 physical SQL servers. 15 on 2000 and 15 on 2005. The company wants to virtualize the 30 servers and upgrade to 2008. In what order should...

nzrdb6

07-22-2009 08:45 AM
Carlos Sacristan

I have the following select statement: SELECT t.territory, td.salesmanager FROM territory t inner join territorymarketcenter tm ON...

mar

07-22-2009 08:02 AM
Plamen Ratchev

Hi All, I want to transfer data from a table in Mainframe DB2 to a table in SQL Server 2005. How can I accomplish the same ? Thanks in Advance

MS Techie

07-22-2009 06:41 AM
Uri Dimant

God Bless You Everyone, I recently upgraded from SQL Express 2008 to SP1. Now my user instances are messed up. When I go into the ASP configuration...

Anthony Smith

07-22-2009 05:26 AM
John Bell

Hi! I have an instance where ss2008 and its database files are installed on the D: and L: drives. The C: drive crashed so the O/S was reinstalled...

Snake

07-22-2009 02:19 AM
Uri Dimant

Hello, I have created a Reporting service report that will execute a SQL agent job inside it. I have tested the report and it runs fine. Now, I...

Abba

07-22-2009 01:51 AM
Abba

I am trying to create a link server from my personal database to our company database. I was looking at MSDN and one of the examples they use...

tshad

07-21-2009 03:15 PM
tshad

Hello, I have this time series data: txId (int unique id) tx_refId (reference to parent record) txTime (datetime) txAmount (float) There are...

Passiday

07-21-2009 09:25 AM
Passiday

Hi, i have this server: - SqlServer 2000 SP 4 - Windows 2003 Enterprise SP 2 - server memory: 14 Gb - PAE enabled in boot.ini - SqlServer: Awe...

Edgecrusher77

07-21-2009 09:12 AM
TheSQLGuru

eMy table is growing and growing and it is simply inserting the rows daily from monitoring systmes. I am thinking to go ahead for partitioning on the...

sacgar

07-21-2009 06:08 AM
John Bell

Hi, I am trying to backup database to an NFS drive with SQL Server 2008. I have installed SFU and I can map the NFS network drive from the...

axel

07-21-2009 04:06 AM
axel

I was able to get my Linked Server working with Remote credentials but could not get it to work using the GUI. This works: EXEC...

tshad

07-21-2009 03:48 AM
John Bell

Hello, I am working on an ASP.NET MVC web site and I need to upload files. I see two options: 1. Save the files on the folder and save the path on...

shapper

07-20-2009 09:41 PM
Plamen Ratchev

Is there an easy way to rename a column in script without copying to a temp table and back? ALTER TABLE doesn't seem to have an option to do...

tshad

07-20-2009 06:13 PM
Gail Erickson [MS]

Environment: SQL 2005 with SP3 Linked Server = Oracle 11g Server We are using the Oracle 10g Client If I made a query the duration takes a very long...

TSSDatabase

07-20-2009 05:15 PM
Erland Sommarskog

Hello there, I have sql 2005 server standard and a user database, I use mixed windows and sql authentication. Although I set the server\Administrator...

Tester

07-20-2009 03:04 PM
Tester

We have a few servers we're currently using for development that,, because they were recycled, have either standard or enterprise SQL 2005 on them. ...

Jack Benny

07-20-2009 01:32 PM
TheSQLGuru

We have a testing process that restores various data sets - in some instances the test team will request backups that are no longer valid and this...

haganahtrainer

07-20-2009 11:43 AM
TheSQLGuru

Hello All, We are completing the process of migrating a SQL Server 2000 server to SQL Server 2008. the last thing to do is migrate (or recreate)...

JaffaB

07-20-2009 11:34 AM
CodeGeek

In SQL Server 2005, I need to append data using restore option. How to deal with this. I need to append data not to overwrite. I tried "RESTORE WITH...

Jayakrishnan

07-20-2009 03:42 AM
Steen Schlüter Persson

Hi all, I need to verify my SQL is the best way to do this (or only way). I have a table 'aspnet_UsersInRoles'. A user can be a customer,...

mazdotnet

07-19-2009 08:29 PM
mazdotnet

Hello, I am new to SQL server administration. I noticed that my backup system didn't backup the log files. Now it does but the log files have a lot...

HDI

07-19-2009 05:45 PM
Erland Sommarskog

I need to allow selected "non-administrative" users to execute a sql job from a client machine via vbscript. More info - The job actually executes a...

Rob

07-19-2009 11:41 AM
Rob

Are dividing tempdb into multiple data files of equal size (each per cpu) and trace flag 1118 still good to use in SQL Server 2008? Thanks, Lijun

Lijun Zhang

07-19-2009 09:23 AM
TheSQLGuru

This proc does not appear to be a part of SQL 2008. (ST.AddGeometryColumn). I imagine it is part of a package from somewhere. If I...

thejamie

07-18-2009 10:07 AM
thejamie

Not yet, I googled around that after installing SP2 or the latest MDAC, the problem will be gone. Thanks <sylvain.sanscartier (AT) tech-nter (DOT)...

mecn

07-18-2009 08:24 AM
Pablo

We are using SQL 2008. I have been looking at BOL on Change Tracking but I'm not sure it does everything I want. I would like to be able to identify...

David C

07-17-2009 05:06 PM
Erland Sommarskog

Hi, I'm using the Database Publishing Wizard against SQL 2005. When I attempt to dump just the data from some select(~150) tables I continue to...

Jay Douglas

07-17-2009 05:00 PM
Erland Sommarskog

i have generic stored procedure and i need to execute dbcc shrinkfile for other database ,since sp does not alloa 'Use' option to change the db ,...

sacgar

07-17-2009 04:05 PM
Aaron Bertrand [SQL Server MVP]

Hello. I need to grant permissions to specific scalar function in specific database. How Can I deny execution from everyone except 3 specific users...

ampo

07-17-2009 02:34 PM
Uri Dimant