SQLQuest29

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 286 total)

RE: Get record count for a specific database

COMPUTE is depreciated. You can use ROLLUP or GROUP BY
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

October 23, 2013 at 9:31 am

#1660993
RE: Get record count for a specific database

COMPUTE is depreciated. You can use ROLLUP or GROUP BY
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

October 23, 2013 at 9:31 am

#1660992
RE: What’s going on, on my server, right now?

Kim Killian-SiteDataView (7/22/2013)
Comments posted to this topic are about the item <A HREF="/articles/SQL+Monitoring/100615/">What’s going on, on my server, right now?</A>
Have you looked into sp_whoisActive .. it is much more powerful...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

July 23, 2013 at 7:14 am

#1634935
RE: What’s going on, on my server, right now?

Kim Killian-SiteDataView (7/22/2013)
Comments posted to this topic are about the item <A HREF="/articles/SQL+Monitoring/100615/">What’s going on, on my server, right now?</A>
Have you looked into sp_whoisActive .. it is much more powerful...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

July 23, 2013 at 7:14 am

#1634934
RE: Dynamic ETL with SSIS

Martyn Hughes (10/19/2010)
Steve, I've been a great fan of SSC for many years, I've used a number of redgate tools and Litespeed to compress some rather large DBs especially when...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

May 3, 2013 at 8:35 am

#1612236
RE: Search a value to complete database

scott mcnitt (3/14/2013)
I guess if I am learning about a new database that I have been given to support and am searching like this in a development environment, I can...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 14, 2013 at 10:57 am

#1597145
RE: Search a value to complete database

Below one is more efficient and gives more info as well ... I have used it many times and its a life saver
Credit goes to -- Luis Chiriff
/*
- Search through...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 14, 2013 at 8:14 am

#1597022
RE: Sql server DBA for near future

sqlpanther (2/19/2013)
hello All,
I have a little question about DBA job future in near time, as there is a gradual shift fto cloud computing, I get a doubt sometime will cloud...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 22, 2013 at 10:24 am

#1590442
RE: Execute permission was denied on the object SP_SEND_DBMAIL

eyespi20 (2/18/2013)
We moved our production databases from an SQL2008R2 Standard Edition to SQL2012 Enterprise edition this past weekend. I have a DBMailUserRole defined in MSDB that has the execute rights...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 22, 2013 at 10:18 am

#1590439
RE: Restore failed for Server. (Microsoft.SqlServer.Smo)

margo.taylor (2/21/2013)
I have been trying to restore a backup to my test server and keep getting the following error. I am using Microsoft SQL Server Management Studio.
Restore failed for...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 22, 2013 at 9:57 am

#1590428
RE: Need a script for IIS log file size threshold limit exceed

Kumar-386306 (2/21/2013)
Hi Guru,
if any have a power shell script to track the IIS log file size and send a email alert if the log file size exceeds certain limit.
Please...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 22, 2013 at 9:45 am

#1590424
RE: Database in Recovery mode from last 7 days.

parminder.parmindersingh (2/6/2013)
Hello,
Please any one can help me, how to recover databases or change status from in recovery to normal. i had go through all the articals which is suggested by...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 7, 2013 at 9:37 am

#1585531
RE: model database transaction log

sqlfriends (1/22/2013)
It sounds to exclude it from full backup is a good idea, and do a full backup whenever there is a change.
One thing I need to change though, when...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 23, 2013 at 8:33 am

#1580126
RE: Track Database growth

sqlfriends (1/22/2013)
Anyone knows a third party SQL sever monitor tool that has functionality that can track database file size growth?
Whoops, the topic should be track database growth, I don't have...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 23, 2013 at 8:25 am

#1580120
RE: Extended Events Database File Change

How about using the blackbox trace that is already running ?
This might help you.
http://technet.microsoft.com/en-us/library/cc293615.aspx
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

November 19, 2012 at 10:37 am

#1560450

Viewing 15 posts - 16 through 30 (of 286 total)