| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hello,
I need to conduct a session to SQL developers on the below topics. Does
anyone have a list or powerpoint or url that I can use?
1. Best...
Abba
|
10-12-2009 01:14 AM
Abba  | 2 | 63 |
| | | "TheSQLGuru" wrote:
Thank you for answer, sometimes it is true but not always, for example look
at Nagios, it is free and used for a lot of people...
anxcomp
|
10-11-2009 03:19 PM
anxcomp | 1 | 27 |
| | | Hi,
i defined a field as INT which is primary key and which has Identity
Specification=YES and with Identity Increment = 1.
Now i deleted the whole...
Luc
|
10-11-2009 07:00 AM
Erland Sommarskog | 4 | 24 |
| | | Hi Gurus,
I have 30 big instances to upgrade to SQL 2008 (15 SQL 2000 and 15 SQL
2005). Space is tight on each dataserver. I'd struggle to do a side...
nzrdb6
|
10-11-2009 04:13 AM
Uri Dimant | 1 | 47 |
| | | Hello,
i have to proceed an update on a large table. I joint my sql query on the
bottom of message.
But i don't know the best practise for this type...
Luipon
|
10-11-2009 04:05 AM
Uri Dimant | 3 | 58 |
| | | Hi,
I am having a mysterious problem with data was inserted into a table with
extra 1 character or digit in the value.
For exp, I have a column with...
Tien Tran
|
10-10-2009 04:08 AM
Erland Sommarskog | 2 | 41 |
| | | TITLE: Microsoft SQL Server Management Studio
------------------------------
Backup failed for Server 'SERVER-DB1\DATABASE'. ...
GKS
|
10-10-2009 03:56 AM
Erland Sommarskog | 3 | 130 |
| | | In SSMS for 2008, is there a way to have the program show all the tabs on
one screen instead of about 7 of them and the rest in a list? I thought...
tshad
|
10-09-2009 10:50 PM
Sergey Vlasov | 2 | 28 |
| | | I have a serious performance problem associated with use of parpameterized
queries through an ASP.NET application.
When using SQL profiler to...
Jeff Cleath
|
10-09-2009 04:57 PM
Erland Sommarskog | 3 | 126 |
| | | Hi,
One of the nice features of SQL2008 is the ability to give a color to the
connection. We have setup an SQL2008 Central management server to...
Chris Wood
|
10-09-2009 04:56 PM
Chris Wood | 4 | 30 |
| | | In attempting to resolve a problem (see "can't find Maintenance Plan" if
you're curious) I've gotten my SQL completely jacked up. At this point...
Don Powell
|
10-09-2009 04:01 PM
Lucas Kartawidjaja | 2 | 148 |
| | | I just installed SQL Server 2008 Developer Edition with SP1 on my laptop, and
when I connect to the instance that gets installed locally it says...
cbrichards via SQLMonster.com
|
10-09-2009 03:46 PM
Lucas Kartawidjaja | 1 | 41 |
| | | Hello!
I would like to implement SQL Server auditing using DDL triggers (capture
DML, permission, etc. audit log). I was wondering how much overhead...
Igor Marchenko
|
10-09-2009 12:21 PM
Igor Marchenko | 0 | 29 |
| | | I have a SQL Server 2005 database instance that I would like to change
auditing from 'failed logins only' to ''both failed and successful...
Joe K.
|
10-09-2009 11:18 AM
Joe K. | 0 | 25 |
 | | Thanks. That was the trick! servername,portnumber
and I did not include the instance name - just the computer name followed by
the portnumber...
Rich
|
10-09-2009 10:44 AM
Rich | 10 | 161 |
| | | I'm trying to setup a Maintenance Plan to backup my SQL 2005 databases but
when I launch the Management Studio I don't find a Maintenance Plan...
Don Powell
|
10-09-2009 01:53 AM
Tibor Karaszi | 4 | 44 |
| | | Hello,
This is not a techie post and is rather asking for guidance and suggestions
for improving my career as a SQLDBA.
I have 11 years total IT...
Knappan
|
10-08-2009 11:16 PM
Knappan | 2 | 23 |
| | | I have an SSIS package that has a script task to creat a Chart in a new
window in Excel and send it via email. When I run the package from... |
10-08-2009 10:16 PM
Dave Patrick | 1 | 25 |
| | | Is there a tool that will display an index graphically? In the form
of a tree.
Cheers,
Aeden
aeden.jameson@gmail.com
|
10-08-2009 05:13 PM
Jeroen Mostert | 2 | 95 |
| | | Hi,
I have 2 stand alone SQL 2005 machine which run on Windows 2000. The OS on
these 2 stand alone machines is going to be upgraded to Windows 2003...
kunalap
|
10-08-2009 04:03 PM
Jeroen Mostert | 1 | 121 |
| | | Hi All,
I have a prepared statement which i execute through jdbc, it is a simple
select statement with 200 parameters in the IN clause. The...
Rashmi Dharshan
|
10-08-2009 03:58 PM
Rashmi Dharshan | 1 | 120 |
| | | Hi:
There are some good answers to questions out there about changing the name
of a server that hosts SQL Server 2005, by using sp_dropserver...
Tone-man 123
|
10-08-2009 03:04 PM
David Hay | 7 | 38 |
| | | Can I disable maintenance plans from a batch file? I would prefer to just
disable the plan but if I need to disable every job in the...
Saucer Man
|
10-08-2009 02:36 PM
Saucer Man | 2 | 26 |
| | | SQL Server 2005. Windows Server 2003.
I have two tables as follows (this is a small test):
Constituents
ConstitID (Primary...
Chaplain Doug
|
10-08-2009 02:06 PM
TheSQLGuru | 6 | 48 |
| | | We'll be doing an in-place upgrade from SQL 2000 Std SP2 to SQL 2005 Std SP3.
This server is sized sufficiently with 4 Gb ram. We have ~244...
Sharkzak
|
10-08-2009 12:06 PM
Sharkzak | 0 | 42 |
| | | I am having the same problem. Have you found a solution for this yet?
cw wrote:
Using SSMS2008 to view Job Activity Monitor on...
Jubmar Davis
|
10-08-2009 11:57 AM
Aaron Bertrand | 1 | 27 |
| | | Hi,
I'm using SQL Server 2005 and get the following error while trying to backup
a database.
"System.Data.SqlClient.SqlError: Failed to pause...
Eduardo
|
10-08-2009 11:47 AM
Vlad Bakman | 1 | 31 |
| | | Does anyone have MS SQL Server Engineering interview questions?
Sejoo
|
10-08-2009 10:07 AM
Sejoo | 0 | 28 |
| | | Hello,
Can I generate a list of tables and columns used by a view?
Is there in the information_schema the information which table,...
ben brugman
|
10-08-2009 09:54 AM
ben brugman | 1 | 21 |
| | | Hi,
If I put a bunch of commands (insert into..., update table... x 10, drop
table.....) wil the server then first check the whole syntax before...
Eric
|
10-08-2009 09:46 AM
Linchi Shea | 4 | 30 |
| | | Hello,
I'm using the page http://support.microsoft.com/kb/930615 tutorial to
schedule a daily backup on my database.
Backup works fine, and I'm able...
wc
|
10-08-2009 02:28 AM
Abba | 1 | 48 |
| | | Is there any stats showing how many databases and sql server that a dba can
handle. I have 60 sql servers and I'm drowning. In requesting...
brymer28303
|
10-07-2009 11:24 PM
Abba | 10 | 87 |
| | | I apologize if this is posted in the wrong place. It seems to overlap a
number of products.
We have a SQL Server 2005 Standard SP3 database running...
Sierra
|
10-07-2009 09:34 PM
Lucas Kartawidjaja | 4 | 37 |
| | | i have 64bit box with standard 64bit 2005 version on it. it is a clustered
setup. i have 40G phisical memory on the box and constantly...
gremlin321
|
10-07-2009 06:51 PM
Greg Linwood | 2 | 54 |
| | | Hello,
--DDL start
CREATE TABLE .(
IDENTITY(1,1) NOT NULL,
NULL,
(9, 3) NULL
CONSTRAINT PRIMARY KEY CLUSTERED
Abba
|
10-07-2009 03:06 PM
--CELKO-- | 4 | 31 |
| | | Hello,
I just run a test upgrade on SQL 2000 ENT (SP4) to SQL 2005 ENT. I took the
default instance (in place upgrade?).
The installation completes...
tnt
|
10-07-2009 02:53 PM
tnt | 8 | 25 |
| | | On the production server a db is comprised of app.mdf and app_log.ldf.
When I do a backup and restore to another server, the ldf is always
created as...
mat
|
10-07-2009 01:47 PM
Tibor Karaszi | 12 | 72 |
| | | Hi,
Considering this backup plan:
- Sunday: Full backup
- Mon - Sat: Differential backup
Says, on Wednesday, the backup is running half way, it was...
wodoy.peter
|
10-07-2009 12:33 PM
Tom Cooper | 1 | 30 |
| | | I have a job run at 3 am that does an reindex of the databases and then a
backup of the databases.
Well 2 days ago it started to fail, the first...
swamper via SQLMonster.com
|
10-07-2009 11:06 AM
swamper via SQLMonster.com | 10 | 61 |
| | | I have a SQL Server 2005 database server that has numerous databases with
application roles. I am looking for a script or command to output...
Joe K.
|
10-07-2009 03:44 AM
Uri Dimant | 1 | 47 |
| | | Hi,
I have a log shipping setup between two servers. There is a need to
utilize the database at the subscriber once a week and then replace it
with...
tolcis
|
10-07-2009 03:39 AM
Uri Dimant | 2 | 55 |
| | | http://sanssql.blogspot.com/2009/09/search-for-table-in-all-databases.html
Regards,
Sandesh Segu
http://sanssql.blogspot.com
Sandy
|
10-06-2009 11:24 PM
SandeshSegu | 2 | 50 |
| | | When have a linked server defined between two SQL 2005 SP3 64bit servers.
When running a program we get the following error "OLE DB provider...
Reis, Tom
|
10-06-2009 04:49 PM
Erland Sommarskog | 1 | 40 |
| | | Hi
I have a db with a mdf file of size 5TB (Terabyte). I have truncated much
of the tables in the db. When i try to shrink file using ssms...
ujjwol
|
10-06-2009 12:50 PM
Andrew J. Kelly | 7 | 36 |
| | | All,
I'm trying to test sending mail using SQL Server 2005. I have configured
database mail but I'm getting the following error:
The mail could not...
Jamal
|
10-06-2009 07:09 AM
pramit | 5 | 81 |
| | | I tested
select * from table with (NOLOCK)
select * from table with (READCOMMITTED)
amd was surprised to find READCOMMITTED cause insert times...
Scott
|
10-06-2009 06:13 AM
Scott | 10 | 95 |
| | | http://sanssql.blogspot.com/2009/09/search-for-column-in-all-databases.html
Regards,
Sandesh Segu
http://sanssql.blogspot.com
Sandy
|
10-06-2009 04:16 AM
Madhivanan | 2 | 58 |
| | | I'm trying to put parts of a stored proc into a table valued function
so the result can be used elsewhere. The stored proc, and hence the
function,...
Jeremy
|
10-05-2009 10:49 PM
Linchi Shea | 8 | 34 |
| | | I have a issue where I am trying to get reporting services report of a sql
2000 analysis database. Both are separate servers.
I can get as far as...
Sammy
|
10-05-2009 04:56 PM
Sammy | 0 | 21 |
| | | i have an access front end with sql back end, all works fine with
sql-2000, but when i have updated sql to sql-2008 express that
started
the...
Ghost 63
|
10-05-2009 04:39 PM
Erland Sommarskog | 1 | 20 |
