sql maths:price / ? --> one decimal before the last digit

All, I have something different scenario. select 000031761 select 000000500 select 000000005 select…

Fact Table Partitioning

Hi Folks, Can any one let me know the best way to partition the fact table in SQL Server? Currently…

Sql Server Configuration Manager problem

Hi Friends, Now Windows Management Instrumentation Service is Pausing mode. How to start the WMI(Wi…

Size of the database data file (not the log file) accurately

Is there any T-sql that will return the size of the database data file (not the log file) accuratel…

View

Can u plz share a query which will retrive below information from a view? 1. Columns names of the v…

Distributed Transaction

Hello, I have a question regarding distributed transactions. I have 2 SQL servers, each linked to …

Hi, What I need to do is to combine (join) recordset from Data Conversion (which has input from XML…

Master db being hammered

We have noticed that the master db is currently being hammered on one of our servers. When you loo…

connecting to Oracle with network authentification

hi i'm trying to connect to Oracle in connection manager... i can connect ok in TOAD by leaving the…

Running SSIS Packages in Batch file remotely

In our existing environment, We have SQL 2005 and Varicent Tool on same box. We have specific SSIS …

Auto Create Statistics and Compilation locks

sql 2000 database which has a check mark on Auto Create Statistics. If all the other option on th D…

Logshipping

Hi Can any one please, tell me that when we configure log shipping do we have to open a firewall f…

sql server bug, configuration issue, different NULL handling 32-bit vs. 64-bit?

Hi all! I have this query: SELECT LEFT(NULL,ABS(CAST(CHARINDEX('.',NULL) AS INT)-1)) -- or it's sim…

Number of users?

Right click master DB of any server and this shows that the Number of Users = 6 in General tab. Is …

Recursive Query using CTE with SQL server2005

Hi, I have 2 tables User UserId UserName LoginName ============================ 1Vijay Teache…