Tagged Questions
-2
votes
1answer
28 views
Sorting and saving as a new table
I have a table named “Unsorted Name”
Name Grade
Z 3.4
T 3.8
A 3.5
B 3.6
I want to sort the name in ascending order and want to save the new table as named: “Sorted Name”
Name Grade
A ...
1
vote
0answers
31 views
COMMIT_TABLE wait type
We recently upgraded hardware and database versions (SQL Server 2008R2 Enterprise to 2012 Enterprise) in our production environment. We also make significant use of change tracking in order to merge ...
0
votes
0answers
16 views
Update Multiple Values In Xml with .modify method
I have looked over release documentation for the 2012 SP1 release of Sql Server
and reviewed this old post.
TSQL 2005, XML DML - Update Two Values at once?
I am wondering is it possible to ...
0
votes
1answer
126 views
Assign proper fill factor option for each index
I use SQL Server and want to assign proper fill factor value for each indexes. I know below parameter for each index:
Row count of each table
Amount of Scan occurred for each index
Amount of Seek ...
3
votes
3answers
6k views
How to convert SQL Server 2008 R2 database to SQL Server 2012?
I installed SQL Server 2012, and attached a database originally generated by SQL Server 2008 R2.
Everything appeared to work perfectly, with one problem: merges dropped from 1000 per second to 10 per ...
1
vote
2answers
50 views
Add top row value to current row based on condition
my current tabular output is
---------------------------------------------------
| id col1 col2 |
...
0
votes
1answer
48 views
SQL Server Database Diagram Show relationships
There is a database online that I was able to download. It came in Access, I exported it to SQL Server. It works beautifully. However when I create a diagram, it doesn't show the relationships. By ...
1
vote
1answer
79 views
Can you replicate from SQL Server 2012 to 2008 R2
Quick question: can you replicate a database from SQL Server 2012 to 2008 R2?
We currently have a push transactional replication setup from a SQL Server 2008 R2 database (publisher) to another 2008 ...
0
votes
1answer
36 views
Count Days using Dense Row function
I have a table which contains data for all the action performed on a particular object. The table below appears something as follows:
ActionId ProductName ProductPart ActionDate ...
1
vote
1answer
26 views
Sql Server Value Method Returning only one value not multiple
I am trying to return multiple element values into rows and I am running into the below issue of it not returning all instances in rows, I have isolated the issue down to a singleton problem. I have ...
1
vote
1answer
15 views
SQL Server : returning the related xml with value, nodes methods
I have a the below sample XML schema that I am querying from in SQL Server 2012. I have a table with a XML column. I want to include the snippet of xml when each row is returned.
Below is the ...
1
vote
1answer
24 views
Right after establishing a new connection to a DB need to execute a specific TSQL command. All is under EF5.0 (Model First)
Using Entity Framework 5.0, and MS SQL Server 2012. Implementing some cell level encryption functionality. This requires a specific set of actions to successfully encrypt/decrypt data:
Open ...
2
votes
1answer
63 views
Customize Templates beyond Grid
How can I add custom sql commands to the default templates(used for when you right click a table and then use Script Table as... then click one of those options)?
Instead of:
UPDATE DB.dbo.table ...
1
vote
2answers
33 views
Alter clustered index column
I have a clustered index on a table indexing on the text column. I want to switch that column with a different column like ID, how do I alter the index?
I can't drop and recreate because this is ...
0
votes
2answers
80 views
Delete duplicate records after combining multiple primary keys
I have a scenario where there can be multiple types(type1 : xxxxxx, yyyyyy and type 2: aaaaa, bbbbb) associated for the same num(provided the condition same user name
I mean there can multiple ...
0
votes
1answer
56 views
Syntax error when defining a parameter for BULK INSERT
In the following C# code:
string filePath = @"C:\Users\Me\Documents\note.txt"
var SqlSaveCommand = new SqlCommand(@"BULK INSERT table FROM @filepath", con);
SqlSaveCommand.Parameters.Add(new ...
0
votes
2answers
107 views
Inserting data from a text file directly to an sql table
for example if i had a text file in the following format
A
B
C
D
E
.
.
.
and an sql table calld table with column called letters
i want to insert each value in the text file to the column letters, ...
0
votes
0answers
58 views
Best Practices for Replacing SQL 2008 Native XML Web Services
We are currently using SOAP/HTTP Endpoints in SQL Server 2008 to make some stored procedures available to our SharePoint based website. We are now planning a migration to SQL 2012, which doesn't ...
0
votes
2answers
122 views
Copy Data using SSIS
I have more than 100 tables in a database. I generate script and execute into another database. Now I want to insert data from source database into destination database (only data) daily basis.
So I ...
-1
votes
1answer
70 views
How Should we know the DMV got flushed in Microsoft sql server
Hi i am using SQL Server and i would like to know whether DMV got flushed and when?
2
votes
3answers
522 views
SQL linked server with filemaker
I have a client with FileMaker Pro 11 Advanced.
I need to be able to connect to the filemaker database via SQL. I am using MS SQL Server 2008 R2, or Server 2012 can be used.
These are the steps I ...
-1
votes
1answer
85 views
How to open SQL Server 2012 using run prompt [closed]
Hi i am using SQL Server 2008 R2 and SQL Server 2012.how should i specify whether i have to open SSMS 2008 R2 or SSMS 2012 using run prompt when i did run -> SSMS.let say for now i have to open SSMS ...
0
votes
1answer
41 views
how to resolve error “Text Line Should not be null” while comparing two DB using VSTS
Hi i am using VSTS2010 to compare two build using schema compare. today encounter an error while compairing "Text line should not be null" and suddenly got error "Microsoft Visual Studio has ...
2
votes
2answers
58 views
Useful Non-System Procedures in SQL Server [closed]
Still rather new to SQL Server and learning as much as I can!
I have been looking over great system stored procedures and documenting when and where to use them. It brought me to a question I ...
-3
votes
1answer
138 views
Licensing SQL 2008 R2 Processor License while SQL 2012 is available only [closed]
We are looking to install SQL Server 2008 R2 - given that the licensing model has changed ever since SQL 2012 came out (Processor licenses no longer available) and the 2008 R2 Processor license no ...
1
vote
2answers
206 views
Limit SQL Server log file growth rate
I have a big database of 2.3 billion rows and size of 76gb.
My problem is that I want to convert a column type to smalldatetime but during this operation the .ldf file grows so big that it takes my ...
1
vote
2answers
384 views
How To Use 'Select Row Number()' With Multiple Tables
I tried to Use ROW_NUMBER() clause to retrieve a specific row number
when i execute this query
SELECT
student.Aca_num,id_num,student.name,dob,pic,class.name,
...
0
votes
2answers
339 views
SQL inner join two tables from separate databases and update one of them
I have the following SQL query:
UPDATE db1.dbo.oitems
SET f2 = oo.f2,
f3 = oo.f3,
f4 = oo.f4
FROM db1.dbo.oitems o
INNER JOIN db2.dbo.oitems oo
ON o.orderid = oo.orderid
Each ...
2
votes
3answers
185 views
Joining parents in 2 tables on exact match of child row values
I have 2 table with below structure :
Table 1 (Tb1) :
MasId Int, ItemId int, Quantity int
1 1 10
1 2 5
1 3 18
2 2 3
2 ...
0
votes
1answer
2k views
Can i install microsoft sql server 2012 system CLR types on windows XP SP3?
I want to install SharedManagementObjects for SQL server 2012 express on a windows xp sp3 machine that has SQL Server 2008 R2 Express edition but does not have any edition of SQL Server 2012.
But one ...
