SAN to SAN hardware level replicaiton to replicate MSSQL 2008 R2 databases
If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases’ MDF and LDF files.

Answer Question   |  February 28, 2013  9:26 AM
MSSQL, MSSQL 2008, SAN

conversion of oracle trigger to MS SQL
how can i convert an oracle trigger into MS-SQL?

Answer Question   |  October 12, 2011  1:49 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server

Ageing Report T-SQL
Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for each period The Billing table is pre-populated with the charges per month as per the amortization schedule when a client [...]

Answer Question   |  March 31, 2012  1:29 PM
MSSQL, SAP Aging Reports, SQL 2005, T-SQL

MSSQL 2008 sudden and drastical slow down – IT telephony
Hi, I’m a newbie, greeting everybody from Hungary, and thanks for your time Generally the SQL system runs smoothly. There is a SP which runs two times daily, and it logs the begin/end times. It takes about 20 minutes each time, normally. Suddenly I see that it takes 3-4 hours. Each time the same degradation. [...]

Answer Question   |  March 31, 2012  6:28 AM
MS SQL Server, MSSQL, SQL 2008, SQL Server

Kerberos unconstrained delegation for MS SQL svc account
Can an MS SQL service account run non-SQL services if “trust this user for delegation to any service (Kerberos only) has been enabled?

Answer Question   |  August 26, 2010  2:11 AM
Kerberos, MSSQL, SQL Server permissions, SQL Server security

Would using a table variable from a function be efficient?
We divided our tables from table zone_a, …_b, …_c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it’s specific table, and the same with the other remaining table. Since per table holds thousands of data [...]

Answer Question   |  May 19, 2010  7:16 AM
MSSQL, SQL tables, SQL variables

mssql login script
Hello, Can anyone give me a simplet powershell script to check login attempt to remote MSSQL database.For eg: if i have a database “db” in remote sql server say 192.168.1.10 which having username”test” and password as “password”.If the login is successful its output should shows as “OK” in powershell prompt itself or  as “FAIL”,if it [...]

Answer Question   |  February 18, 2010  8:29 PM
MSSQL, PowerShell Scripts, SQL 2005, SQL scripts, Windows Server 2008

what is different from MSSQL, MYSQL and Oracle 11g?
what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

Answer Question   |  January 17, 2010  2:55 PM
MSSQL, MySQL, Oracle 11g Database

ms sql query problem with a case statement
[strong]This code works: SELECT     passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit                        FROM         passengers INNER JOIN                       hyperjump ON passengers.pass_terms = hyperjump.startsystem AND passengers.pass_system = hyperjump.endsystem CROSS JOIN                       passship WHERE     (passship.passship_name = ‘Rinkratt’) ORDER BY ptprofit DESC, [...]

Answer Question   |  October 18, 2009  3:02 AM
CASE statement, MSSQL, SQL

Getting last entries from two different tables
Hi, I need to get the last entries from two different tables in MSSQL. I can get the last entry for one table by usung the following. SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) The problem is adding another table. Please help

Answer Question   |  September 29, 2009  7:29 AM
MSSQL, SQL tables

EMC networker MSSQL Restore hangs
I am trying to restore the model database on a EMC MSSQLv5.1 client The EMC server is version 7.4.2 When running the restore we can see no activity on the Client and in the Networker console it shows the server as “browsing”. In the devices tab no tapes are loading and nothing is reading from [...]

Answer Question   |  May 13, 2009  5:25 PM
EMC, EMC NetWorker, EMC Server 7.4.2, MSSQL

SQL Find a number between the given ranges of number / Find a row which has range of given number
I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: [...]

Answer Question   |  December 5, 2008  2:53 PM
MSSQL, SQL, SQL tables