Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

Is there a way to query a server's power plan settings using T-SQL?
Hello, Something that has recently appeared on my radar is power plans on a server and how their configuration impacts the performance of SQL Server on any given sever. We have a stored proc that spawns threads to each instance on a server and

asked 11/2/2014 11:50:28 AM
by Jason
1 answers

how can FIND READ_WRITE_I/O WAIT with specific time intarval
Hi All, I need to find Total_MB_Reads,Total_MB_Writes,IoStallMS of a database  with spefic time interval i.e for 1st of september ,10th of september... i run below query  on  31st of oct: so how can i find those information for previo

asked 10/31/2014 6:28:50 AM
by Subhamay Chatterjee
1 answers

Would I get some assists regardig changing data capture when time stamp is not presesnt for the records.  

asked 10/30/2014 9:29:07 AM
by Wagdi Eltayeb
0 answers

SQL Editionto use ODBC
Good afternoon, I need to buy SQL Server 2014 for my company but I am using DSN and ODBC connections, which edition should I be using, Standard or Enterprise. From what I saw in the features at Microsoft,  I should buy the enterprise. Am I correct?

asked 10/30/2014 9:07:34 AM
by Mohamed
2 answers

Hi,         I want to audit my database that which user inserting,updating and deleting database from a website. If a user update any data then i want to see what was previous(old) value as well as new value.I used ApexSqlTool for thi

asked 10/29/2014 2:33:28 AM
by Roopesh Jain
1 answers

Generate Scripts without Replication Items
I have a database that uses Transactional Peer to Peer replication on SQL Server 2008 R2. Periodically, I need to generate scripts (schema only) to send to other offices who do not have access to my servers to utilize. Normally, I use the Generate Scripts

asked 10/28/2014 8:48:19 AM
by Patrick
1 answers

sharepoint list source error
I got below message while executing a package which takes data from sharepoint source through sharepoint list source: Error Message:Code: 0xC0047062     Source: Load STG DAPriority SharePoint List Source [1]     De

asked 10/27/2014 4:20:47 AM
by sravani
0 answers

How to move only SQL reporting services from one server to another? Report Database is on separate SQL server
Hello, We are having SQL reporting services installed on application server and Report Database on SQL DB server. We are upgrading OS of Application server and need to reconfigure reporting services on new server. How to proceed so that all reports and

asked 10/24/2014 4:33:55 PM
by Shelly
1 answers

Hi Team can somebody provide me the course syllabus or topics being covered in MSBI Learning(SSIS,SSRS,SSAS)   Sincerely Suri

asked 10/24/2014 6:17:29 AM
by Suri
1 answers

To make sql server instance back to multi user mode
I have made a change at instance level, ‘Properties/Connections/Maximum number of concurrent users’ to 1, disconnect all other users from the server. Since some of the users were logged in and left for the day and I had to restore the DB, I

asked 10/23/2014 6:25:43 PM
by Jacob
1 answers

How to save ssrs trace log data to SQL Server database table?
I am working on a project which is required to create a datamart to collect data from executionlog, ssrs performance monitor counters, and ssrs trace log in order to use ssrs to generate some reports. Any suggestions are welcome, particularly for how to m

asked 10/23/2014 11:42:24 AM
by John
0 answers

relational DB

asked 10/23/2014 6:25:55 AM
by Joćo Rodrigues
0 answers

Decimal separator: Comma and Point
I have a problem with decimal separator that I can explain with this simple line: select convert(money,1.1), convert(numeric(4,2),1.1) will return  1,101.10 I realize that numeric types does not respect the language culture.  If I install th

asked 10/23/2014 6:08:34 AM
by Celso
0 answers

How to get the start time and end time of process ssis
I have an ssis package , where I includes a foreach container to loop through files and loads it in to a table. Now I want to track the process start time , end time and the status into another table. How can I achieve this.. ?

asked 10/22/2014 1:53:13 AM
by Hazeena
1 answers

import word content into sql server
hi professor for example :i have a word file and its content is formula,text,image i wanna creat DB with them for instance i had 2colmns .one for image and one for formula and can search  thanks professor 

asked 10/20/2014 10:24:19 AM
by ehsan
0 answers

Export the table content into excel file
Dear All,   Kindly suggest to me. How I can export the table content into excel file or text file or csv file. Please suggest your answer.

asked 10/18/2014 1:32:25 AM
by Rakesh Kumar Jena
1 answers

Computed Column
Hi,   I have a View with 4 columns ID, DATE, SIGNAL, VALUE. This table is updated everyday for all signal Values. What I want is a Computed colums whose value is COMPVAL= SIG1VAL+SIG2VAL-SIG3VAL. The other SIGNAL types fro 4 to 10 say should reta

asked 10/17/2014 5:43:03 AM
by Ram KV
1 answers

Can not connecting database after installing Microsoft SQL Server 2008 Management Studio Express
Greetings  !! I have Windows XP SP3 operating system (having 32-bit operating system). After downloading "SQLManagementStudio_x86_ENU" from the link ( Normal 0 false false false EN-US X-NONE

asked 10/16/2014 1:59:02 AM
by Mahi
0 answers

Excel Graph from SQL Query
  On the recent webinar "10 Ways to Improve SQL Server Automation" there was an example of moving the results of a job timing query to an excel spreadsheet with graph.  How was this done?  Would be very useful.   Thanks,   Jo

asked 10/15/2014 12:08:14 PM
by John
1 answers

Hi, for the last week i see in the sql server monitoring tool (precies) that the "BRKR TASK" consuming larg amoumt of cpu resorces and cause an Internal waits. the actual text is "Text (N/A) Handle (0x0000000000000000000000000000000000000000) Command (B

asked 10/14/2014 10:47:10 AM
by itzik paz
0 answers

Sponsor Information