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 >>

row level security for end users, all rows for sysadmin users in combination with using “aggregated” tables
  Hi, I trying to implement row level security using AD with IS_MEMBER function in combination indexed views  for aggregated data.   In case query matches the indexed view definition the costs base optimizer should choose the clustered i

asked 12/11/2014 11:31:43 AM
by Wilfried
0 answers

Tempdb error
System SQL SERVER 2005 SP4 Standard Edition. The server this instance was installed on was renamed.  sp_dropserver and sp_addserver (local) were run to fix the name.  Server was restarted and no connection issues were found. I have a inte

asked 12/10/2014 3:09:22 PM
by mkal
0 answers

At end of SQL server 2008 installation in windows 8.1 it hang displaying "RebootMessageAction"
Greetings !! I was trying to install SQL server 2008 in my laptop which the os windows 8.1.  It shows compitibility issue. I solve this issue by right clicking the setup.exe file , went to property tab and change "run this program for in compitibil

asked 12/10/2014 1:02:42 PM
by Mahi
0 answers

Hash Join happening even where conditions are present
Hi,   In below query I have used On as well as Where condition. In execution plan, Index seek is happening for all tables even though Hash Match is happening. Select col1, col2, col3 from table1 T1 with (NOLOCK) INNER JOIN    

asked 12/10/2014 7:48:15 AM
by Ritesh Kumar Singh
0 answers

ODBC Parameter Size
Hi, I have created a SSIS package which runs every hour from my Machine. First part of my Package runs a Execute SQl Task and result set (single row, single column) is a comma separated list of Unique Record Ids which have been updated in last hour. (i.e

asked 12/9/2014 9:33:03 AM
by maulin Thaker
0 answers

The .mdf file grows much after running maintenance plans
Why the .mdf file grows after running weekly maintenance plans? any idea

asked 12/8/2014 12:17:32 PM
by Roy
1 answers

data comparison with minus statement
Hi i have uploaded two tables A & B i have removed inactive components of A as well as B & created a new table C & D now while doing minus ( C-D) i m getting values of C not prsent in D but data involves sme inactive components please hel

asked 12/4/2014 1:48:01 AM
by aryan
0 answers

error message
DECLARE @i AS int = 0;WHILE @i < 28864BEGINSET @i = @i + 1;INSERT INTO dbo.TestStructure(id,filler1,filler2)VALUES(@i, FORMAT(@I, '0000'), 'b');END;GO   When I executed the batch above, after executing for a loooong time, I got the error message

asked 11/29/2014 10:50:52 PM
by Gabriel I. Ruiz
1 answers

Automatically setting Identity value based on column of other value
I am Creating a table such as  student name, class ,roll no roll no is set as identity,information of student is being saved in on table  such as studentname,class,rollno i want such that     student name  class  roll

asked 11/28/2014 2:06:27 AM
by Kunal Choudahary
0 answers

deploy project in sql2012 remotly

asked 11/27/2014 3:03:18 PM
by az
1 answers

Windows Orphan Login
Hi   I created a login at Active Directory WindowsServer Login I registered that login in sql server Later i dropped the login from windows server then in sql server i executed sp_validatelogins, it shows the login at sql server as orphan window

asked 11/24/2014 9:22:45 AM
by ahm
0 answers

VLF rows
Hi, How many VLF rows is acceptable in a trn-file? I have up to 4000 vlf's in one transaction log file. Hope for a clue how to handle this. Ankie

asked 11/24/2014 3:44:46 AM
by ankie
1 answers

Convert to Row
  Dear,I have a task to transfer SP script to dynamic store procedure in SQL Server.The existing SP script is like below :BEGIN    IF @status=1        BEGIN         &n

asked 11/24/2014 2:18:15 AM
by Chairul
1 answers

national security number
hello. i have to hold national security number in  my table. if i get the data type of it longint is better or i get the varchar(10) is bette? what of them has hi performance for compresion ond other task as select. regard

asked 11/24/2014 1:54:49 AM
by hamid
4 answers

how to interpret results of set statistics time on in a multi core CPU enviorment
I am novice at query performance optimization. As Io and time statistics quantify query performance I usually check time taken by query through "set statistics time on" after cleaning buffers and dropping proc cache. In one of my quires CPU time is consis

asked 11/23/2014 2:38:08 PM
by Tanmay Jambavlikar
0 answers

  I have two windows 7 os. machine. One make server and another is client machine . peer to peer connection between server and client. i used to SQL Server 2008 express.  In server machine all software is easly run. but in client machine when

asked 11/23/2014 11:55:36 AM
0 answers

Import excel with approx 15000 rows daily into sql server
I have a requirement to daily import 8 to 10 excel files, each containing around 15000 rows of data in multiple sheets. Application is using Microsoft .net 4.0, SQL server 2008R2. Application then daily generates reports based on this data imported into S

asked 11/23/2014 8:21:03 AM
by Tricandure
0 answers

Building a link from SQL Server 2008 to Access

asked 11/20/2014 5:56:56 PM
by Donald
0 answers

SQL Query to calculate OnPeak & Off Peak total for a month and find the highest max onPeak & Off Peak hourly value for that month
Could someone help me with a SQL query to calculate the total on-peak and off-values for a month as well as the Max/highest on-peak/offPeak hourly value for that month.   On a daily basis i store the hourly values of the meter in a SQL table. &nbs

asked 11/20/2014 8:45:07 AM
by Shiva
0 answers

how to convert 3 column table into 2 column table
I have a TableA with 3 columns, Column1, column2, column3; and I want to convert it into 2-column TableB. If Column2 & Column3 in Row N of Table A is not Null, I want TableB like this: Row N,       Column1, Column2 ;

asked 11/19/2014 9:24:47 PM
by vivian
0 answers

Sponsor Information