• how I can connect my local SQL server2008 with another one via internet?

    how I can connect my local SQL server2008 with another one via internet?

    Netkrom10 pointsBadges:
  • Slow response with SQL server over a network.

    Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank you for...

    Jack26015 pointsBadges:
  • How to move sql server clustered instance to a separate stand alone server

    We are in the process of moving our Production instance and databases. Would be of nice help if anyone could shed their thoughts on How to move sql server clustered instance to a seperate stand alone server (along with system and user databases). We are stopping the cluster, moving the drives to a...

    Sqlserver2008r25 pointsBadges:
  • SQL Server 2008 Insert Into vs Insert Statement Recompile

    I have a stored procedure that executes a t-sql statement using sp_executesql. This t-sql code recompiles everytime it runs using "INSERT INTO" but when I use "INSERT" only it will not recompile. What is going on here? sample: create table #test (id int) Recompile: insert into #test select id from...

    Rick Martinez585 pointsBadges:
  • What is Broker EventHandler Wait Event?

    I keep seeing this wait stat "Broker_EventHandler" in the SQL Server wait stats with high duration times. What is Broker_Eventhandler? Why does it have high wait times?

    Rick Martinez585 pointsBadges:
  • Should I enable service broker on SQL Server 2008?

    I am not too familiar with service broker, should I enable it on all databases on my production server? If yes why?

    Rick Martinez585 pointsBadges:
  • How to determine proper max memory setting

    How do I determine the proper max memory setting for our system? We have Windows server 2003 R2 entreprise ed, sp2. It is 32 bit. There is 8.00 Gb of ram. We have just upgraded to SQL Server 2008 sp1, enterprise ed. Now we're having some memory problems. Thanks very much for any help with this.

    denise7525 pointsBadges:
  • SQL Server Data File Storage

    We have a SQL Server with 32GB of RAM, 8 CPU 16 Cores, using SAN. On our production database (1 database only) we have 3 file groups Primary, Core, Index with 1 file in the PRIMARY Group, 16 Files in the Core Group, and 16 Files in the Index Group. Each file group including all data...

    Rick Martinez585 pointsBadges:
  • SQL SERVER Data Files and Threads

    I am reading a Microsoft Press Book MCTS Exam 70-432 and in chapter 2 it talks about Data Files and it says "SQL Server creates a thread for each file underneath a database. As you increase the number of files underneath a database, SQL Server creates more threads that can be used to read and write...

    Rick Martinez585 pointsBadges:
  • Combining 2 queries in SQL 2008

    I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it's possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN '1/1/2010' AND '12/31/2010') GROUP...

    DavidHa!!110 pointsBadges:
  • How I can automated process load xml file to SQL server 2008?

    Hello!

    Ana6335 pointsBadges:
  • SQL Server and AntiVirus

    We have many sql server running on seperate boxes, the Network team wants to install antivirus software on all the sql servers. Is that a good idea? Why?

    Rick Martinez585 pointsBadges:
  • Web development course and Microsoft qualifications

    I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web...

    Tobeeornot25 pointsBadges:
  • International SQL Server Replication

    I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for...

    MattPoirier15 pointsBadges:
  • Thousands and thousands of simultaneous users hitting a sproc — what do you do?

    folks, i am not a db guy altogether, but I am a developer, and someone had asked me that question, and i got interested in the resolution. Lets say you have 50K users that hit the same stored procedure at the same time. The stored procedure is computation intensive and goes out to lunch for a bunch...

    Oscarius5 pointsBadges:
  • Complex SQL query in SQL Server 2008 tables

    Sir, i have 2 tables , first table column one is 1,2,3,4, and column two is x,y,w,z and second table  first column of 1,2,3 second column is (1;2),(1;2;3;4),(2,4), i wand to display the result as in first colum 1,2,3 and second column as (x,y),(x,y,w,z),(w,z) please help me in this regard

    Itoracle5 pointsBadges:
  • SQL server 2005 vs. SQL server 2008

    What is the benefits of SQL server 2008 over 2005 (version 3.5 over 2.0)?

    Ryzawack15 pointsBadges:
  • Implementing a chat using SQLServer Service Broker – how good an idea it is?

    We are designing a chat engine. That's basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session...

    Marcofaustinelli5 pointsBadges:
  • SQL Server 2008 Upgrade

    I have 7 SQL Servers I need to upgrade from SQL Server 2005 to SQL Server 2008. Can I install the SQL Server 2008 prerequisites using Microsoft System Center? If yes how?

    Rick Martinez585 pointsBadges:
  • SQL Server 2008 tables

    I  have 2 tables, tanle1 and table2 Can someone help for  SQL query  for table3 with 2 colums colum 1  is select number from table1 for colum2 in table3  I need to get the total number of times  each number in colum1 of table1 apears in in colums n1,n2,n3,n4 of all events in table2 as shown...

    Ajibola110 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following