Tags » Database Administrator

Ranking Functions – ROW_NUMBER,RANK,DENSE_RANK,NTILE

Ranking Functions – ROW_NUMBER,RANK,DENSE_RANK,NTILE

SQL Server 2005 introduced four new ranking functions: ROW_NUMBER, RANK, DENSE_RANK, and NTILE. These functions allow you to analyze data and provide ranking values to result rows of a query. 626 more words

Database Administrator

Differences between the SET and SELECT statements when assigning variables in T-SQL

It’s many times observed, a SQL Server Developer commonly use SELECT for assigning values to variables. This was fine and a perfectly valid practice till SQL Server 6.5 But SQL Server 7.0 introduced the new SET statement for initializing and assigning values to variables and SQL Server 7.0 Books Online also stated: “ 177 more words

Database Administrator

Finding SP Name or Command text used by SQL server Job

There may be probability that we have hundreds of SQL Server’s Jobs scheduled to run every day on a SQL Server instance.  Here is a script to find quickly the stored procedure or command text used by SQL Server’s Job. 36 more words

Database Administrator

17723 : Direct Client : Lead Application Database Administrator : Cincinnati, OH : 3+ Months (Right To Hire)

Hi,

We are looking for Lead Application Database Administrator for one of our direct client for San Jose, CA. Please have a glance at the below requirement and let me know your feedback, if you are interested for the position please reply us with the attachment of your latest resume. 249 more words

Drop all connections of a database

Its frequently happens when we need to delete a database or restore a database and few users are still connected to that specific Database, it’s through an error saying that database is used by other users. 97 more words

Database Administrator