A little tale and a seven questions about SQL partition - The tale Once up a time a small software shop had a application used Firebird DBMS. The small shop managed to do...
Trying to a Restrict Query by Max Value on Max Date - I already have most of the query I am working with correct Select Clients.rid, Clients.r_fname, Clients.r_lname, Status.StatusFrom Clients Inner Join...
ERROR using CharIndex : Invalid length parameter passed to the LEFT or SUBSTRING function in sql - Hi, I'm using the below function in select query and getting error msg as "Invalid length parameter passed to the LEFT...
concatenate using dynamic SQL - I want to concatenate below table rows using dynamic SQL empno | jobid | vesselno | portid 1 121 1455 1231 1 122 1486 &nbs
SQL Query Help - Hey all, I need a little help with a SQL query. I have a table that has a uniqueidentifier column, a...
Help with SQL Loop Query - Hi Guys, I am using below While Loop Syntax but for some reason, I can't update the records or it...
SQL 2008R2 to SQL 2014 Upgrade - Hi guys, I am planning to upgrade my SQL Server 2008r2 to SQL 2014. As a developer I want to know...
SQL Server | Architecture design - - Hi Experts, I have couple of basic queries regarding the way SQL Server is designed/works: 1) Schemas in SS is bit different from...
SQL help - Need to know the first date of previous month and last date of previous month... - Should be an easy one right ? I like it in YYYYMMDD format
How do I sort this set of records ( SQL HELP please ) - Take a look at the attached screen shot for you you to understand what I need.... 1. ) I need you to...
Query to find when was the database last used - Hello Team, Can you please let me know how to find when all databases on SQL Server were last used. Is...
creating new partition files on table - hello all, I have a table that has 2,948,231,398 trillion rows...I know...last week I had to figure out how to...
Table size and indexes - How many rows does a table need to have before you start thinking about adding an index?
query puzzle - Hello - I have an existing SQL database that keeps track of student information. We use a field called STU.NID to...
SQL server back up - We are currently using sql server 2005. For back up, we use sql server maintainance job to back up all the...
Convert Date Time Parameter to String - Hi, is it possible to convert a date time parameter to a string? I have parameters @StartDate and @EndDate which are DateTime...
SSRS Parameter Search on a long list ids - I am creating a searchable SSRS report where staff can search the data sest on client ids. Staff should be...
No PKs on fact tables - I just inherited a data warehouse where none of the fact tables have a primary key (all fact tables are...
Find Database Dependencies in Jobs and other databases - I'm looking for an article that will help someone determine if a job or other object depends on a database....
Deadlocks on Clustered Index - hi all i have a very simple control table with 1 record, this record manages number increments for various ranges such...
