Which command to reduce log fle ? - Hello Everybody, I have a question concerning Log File : I have to reduce Log file because it's Growing, I'm thinking, this...
RAM Required to run SQL Server + Web Application + SSIS packages - Production Server with following processes running: REST API hosted in IISSQL Server with Data - Majorly for Time sheet and Other application...
when creating FK constraint get error 'statement conflicted with the FK constraint' - been away from development awhile and frustrated by inability to discover underlying issue preventing me from creating FK relationships. The...
backup after a restore. - I am using SQL server native tool to do the full, differential, transaction backup. A question, every time if we do...
Different Query Plan for same query - Hello, I am having very interesting issue. On one SQL instance therea re 2 different databases. Now I am execuitng SQL...
Help with Performance on select count(*) SQL Server 2014 - Have 2 same databases one on test and one on dev in different servers. Whilst trying to run the same...
User-friendly names for constraints - I just noticed that when you create a column with a default value, a constraint is added to the table....
Calculate percentages based on if condition - Hi, I have a query and I need to implement logic to calculate percentages based on if condition in stored...
Reverse ouput - Hi, I am trying to summarize some rows and do a revese output Here is my table data CREATE TABLE mycompanytable( Companyname NVARCHAR(50) NOT...
Dynamic Statement with Cursor loop, help - Hi , I am trying to build a dynamic query which will create a select. I am trying to use a...
float to date - Hi I am trying to convert a "calendar date" column that is a float to date the "date" looks like 201601 ...
How to export particular table list from sql server 2005 DB - Hi , There is an option to export list of tables in sql server. That is export/import wizard. Here actual scenario...
To Delete / Truncate / Drop & Create - Good Morning All, Can I Have some opinions please. Have 2 large tables I need to 'clean', 1 with 265263333 rows and one...
Highest value supported by 2 of 3 columns - Consider a table consisting of an ID number and 3 columns of scores (Score1, Score2, Score3). The final "score" for...
t-sql 2012 parse out multiple values in one field that is varchar(1200) - In a t-sql 2012 database, I am suppose to count the number of times each 'canned' message is used for Elementary...
BEFORE TRIGGER Idea Posted to Microsoft Connect - I have wished for SQL Server BEFORE TRIGGERs for a long time. I have posted to Microsoft Connect (their feedback...
How to delete all store procedure from my database ? - I'm using SQL Server 2008 and its Management Studio. I'd like to delete all user defined stored procedure & views. Is there any...
How to delete all tables except two specific tables ? - I want to remove all tables except two table i.e mytable1 and mytable2 in my db. Is there any script to do...
Looking for best approach - I have two tables. I am looking for an approach where 1)I need to display the data from Table1 if table...
Azure data warehouse - Index maintenance - Hello Folks, How do you perform/schedule index maintenance on Azure Data warehouse. Is there an option to view index fragmentation details...
