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?
Answer Question
| March 2, 2011 4:46 PM
Antivirus, SQL Server, SQL Server 2008, SQL Server security, Windows Server 2003
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?
Answer Question
| March 2, 2011 4:46 PM
Antivirus, SQL Server, SQL Server 2008, SQL Server security, Windows Server 2003
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 [...]
Answer Question
| February 16, 2011 12:14 AM
SQL Server, SQL Server 2008, SQL Server stored procedures, Stored Procedures
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 [...]
Answer Question
| February 16, 2011 12:14 AM
SQL Server, SQL Server 2008, SQL Server stored procedures, Stored Procedures
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 will be a new [...]
Answer Question
| February 3, 2011 4:23 PM
Chat applications, SQL 2008, SQL Server, SQL Server 2008
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 will be a new [...]
Answer Question
| February 3, 2011 4:23 PM
Chat applications, SQL 2008, SQL Server, SQL Server 2008
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?
Answer Question
| February 1, 2011 8:10 PM
SQL 2008, SQL Server 2005 upgrades, SQL Server 2008, SQL Server 2008 administration, SQL Server upgrades
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?
Answer Question
| February 1, 2011 8:10 PM
SQL 2008, SQL Server 2005 upgrades, SQL Server 2008, SQL Server 2008 administration, SQL Server upgrades
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 [...]
Answer Question
| January 31, 2011 1:51 PM
SQL 2008, SQL Query, SQL Server, SQL Server 2008, SQL 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 [...]
Answer Question
| January 31, 2011 1:51 PM
SQL 2008, SQL Query, SQL Server, SQL Server 2008, SQL tables
Can I transfer a SQL license/install to a new server
We are in the process of upgrading on of our db applications to a new version. This version will require a replication server, meaning we will need a SQL server. Ether 2003 or 2008. We will need to have a full working test environment before rolling out live with it. Can we transfer our “test” [...]
Answer Question
| January 26, 2011 7:27 PM
License management, Licensing restrictions, SQL Server, SQL Server 2003, SQL Server 2008, SQL Server licensing, Windows Licenses, Windows Server 2003
We are in the process of upgrading on of our db applications to a new version. This version will require a replication server, meaning we will need a SQL server. Ether 2003 or 2008. We will need to have a full working test environment before rolling out live with it. Can we transfer our “test” [...]
Answer Question
| January 26, 2011 7:27 PM
License management, Licensing restrictions, SQL Server, SQL Server 2003, SQL Server 2008, SQL Server licensing, Windows Licenses, Windows Server 2003
I need to replace a word in a Document through SQL Server 2008
Hello i’m using SQL 08 R2 to store my resume collection , i want Sql to find an Email in the MS WORD document and replace it with an empty string so far I’ve succeeded to find the word using fullTextSearch this my example for finding the documents that contain an email SELECT document FROM [...]
Answer Question
| January 4, 2011 3:52 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server 2008 R2
Hello i’m using SQL 08 R2 to store my resume collection , i want Sql to find an Email in the MS WORD document and replace it with an empty string so far I’ve succeeded to find the word using fullTextSearch this my example for finding the documents that contain an email SELECT document FROM [...]
Answer Question
| January 4, 2011 3:52 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server 2008 R2
SQL servers merge transactions
In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is high and user unable to do data [...]
Answer Question
| December 20, 2010 8:04 AM
SQL Server 2008, SQL Server database, SQL Server synchronization, SQL Server transactions, SQL transaction logs
In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is high and user unable to do data [...]
Answer Question
| December 20, 2010 8:04 AM
SQL Server 2008, SQL Server database, SQL Server synchronization, SQL Server transactions, SQL transaction logs
SOLAP in SQL 2008R2
IS there SPATIAL OLAP implementation in SQL 2008R2
Answer Question
| December 20, 2010 9:28 PM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2
IS there SPATIAL OLAP implementation in SQL 2008R2
Answer Question
| December 20, 2010 9:28 PM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2
Sample Test Data from Production in SQL Server 2008
Is there a data generation tool that can populate tables in a test database with a percentage of actual data from a production database? For example, to extract data based for a date range from a specific table, and all related tables to be populated based on the corresponding related referenctail data.
Answer Question
| December 21, 2010 9:42 PM
Data Extraction, SQL 2008, SQL Server 2008, T/SQL
Is there a data generation tool that can populate tables in a test database with a percentage of actual data from a production database? For example, to extract data based for a date range from a specific table, and all related tables to be populated based on the corresponding related referenctail data.
Answer Question
| December 21, 2010 9:42 PM
Data Extraction, SQL 2008, SQL Server 2008, T/SQL
Create QA database with only some production tables
I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They’re all in the same filegroup in the original database. I’ve done [...]
Answer Question
| December 16, 2010 1:50 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables
I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They’re all in the same filegroup in the original database. I’ve done [...]
Answer Question
| December 16, 2010 1:50 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables
What are the best tools for SQL monitoring and SQL diagrams?
we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?
Answer Question
| December 16, 2010 10:51 PM
Network Monitoring Tools, Network security, SQL 2008, SQL Server 2008, SQL Server administration
we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?
Answer Question
| December 16, 2010 10:51 PM
Network Monitoring Tools, Network security, SQL 2008, SQL Server 2008, SQL Server administration
Hide SQL Server 2008 input parameters
Hi Sir, I wanna help from you . i have designed a report on reportserver . (sql 2008). its includes two variables which are userid and password. Because entering the user id and password , only the data who can view authorised section. User id and password should be keyed and it check with the [...]
Answer Question
| December 9, 2010 6:28 AM
input parameters, SQL 2008, SQL Parameters, SQL Server 2008
Hi Sir, I wanna help from you . i have designed a report on reportserver . (sql 2008). its includes two variables which are userid and password. Because entering the user id and password , only the data who can view authorised section. User id and password should be keyed and it check with the [...]
Answer Question
| December 9, 2010 6:28 AM
input parameters, SQL 2008, SQL Parameters, SQL Server 2008
SQL 2008 job problem
I have a schedule SQL2008 job to export the contents of a table to a text file each day. The job runs fine when I manually execute it, but if the schedule executes it, only 4 or 5 lines of text out of about 13000 are produced to the text file. Any ideas anyone? The [...]
Answer Question
| December 3, 2010 3:28 PM
SQL 2008, SQL job scheduler, SQL Jobs, SQL Server 2008, Windows Server 2003
I have a schedule SQL2008 job to export the contents of a table to a text file each day. The job runs fine when I manually execute it, but if the schedule executes it, only 4 or 5 lines of text out of about 13000 are produced to the text file. Any ideas anyone? The [...]
Answer Question
| December 3, 2010 3:28 PM
SQL 2008, SQL job scheduler, SQL Jobs, SQL Server 2008, Windows Server 2003
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
Answer Question
| February 9, 2011 12:42 PM
SQL, SQL Query, SQL Server, SQL Server 2008, SQL Server 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
Answer Question
| February 9, 2011 12:42 PM
SQL, SQL Query, SQL Server, SQL Server 2008, SQL Server tables
How to transfer database from SQL Server 2008 to SQL Server 2005
how to attach database of sql 2008 into sql 2005
Answer Question
| December 1, 2010 6:13 AM
SQL, SQL Database, SQL Server 2005, SQL Server 2008, SQL Server migration
how to attach database of sql 2008 into sql 2005
Answer Question
| December 1, 2010 6:13 AM
SQL, SQL Database, SQL Server 2005, SQL Server 2008, SQL Server migration
Copy BLOB to BLOB using TSQL
Is there a way I can copy a BLOB from one column to another using TSQL ?
Answer Question
| November 19, 2010 1:37 AM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2
Is there a way I can copy a BLOB from one column to another using TSQL ?
Answer Question
| November 19, 2010 1:37 AM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2
What is the best way to replicate SQL 2008 DBs to a failover site?
We are looking to replicate our SQL 2008 databases to a hot failover site. We can’t use DB mirroring due to the number of databases we have. Has anyone replicated databases to a hot site using a replication solution and what was your experience.
Answer Question
| November 16, 2010 3:58 PM
Failover, SQL Server, SQL Server 2008, SQL Server database, SQL Server replication
We are looking to replicate our SQL 2008 databases to a hot failover site. We can’t use DB mirroring due to the number of databases we have. Has anyone replicated databases to a hot site using a replication solution and what was your experience.
Answer Question
| November 16, 2010 3:58 PM
Failover, SQL Server, SQL Server 2008, SQL Server database, SQL Server replication
Creating second instance on SQL Server 2008 cluster
Hi, I need help to create second instance on SQL 2008 Cluster. I have active/passive Windows 2008 R2 cluster and currently using a default instance of SQL. Most of the blogs mention that installation of new instance is same as the first one and you need to provide IP, network-name and disk resource. But when [...]
Answer Question
| April 19, 2013 5:06 AM
SQL Server 2008, SQL Server 2008 cluster, SQL Server clustering
Hi, I need help to create second instance on SQL 2008 Cluster. I have active/passive Windows 2008 R2 cluster and currently using a default instance of SQL. Most of the blogs mention that installation of new instance is same as the first one and you need to provide IP, network-name and disk resource. But when [...]
Answer Question
| April 19, 2013 5:06 AM
SQL Server 2008, SQL Server 2008 cluster, SQL Server clustering
Powershell 2
Hello I installed PS (ver 2) from windows updates. I have a couple of Q: 1)The event viewer shows a bunch of event id 4374 package not applicable ‘warnings’ but I tried running some cmdlets and they work fine in 2 However, I get an exec of scripts is disabled on this system for version [...]
Answer Question
| October 13, 2010 4:25 PM
PowerShell, PowerShell 2, SQL Server 2008, Windows Server 2008, Windows Update
Hello I installed PS (ver 2) from windows updates. I have a couple of Q: 1)The event viewer shows a bunch of event id 4374 package not applicable ‘warnings’ but I tried running some cmdlets and they work fine in 2 However, I get an exec of scripts is disabled on this system for version [...]
Answer Question
| October 13, 2010 4:25 PM
PowerShell, PowerShell 2, SQL Server 2008, Windows Server 2008, Windows Update
