| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi good afternoon, I always understood that the new DMV
to be consulted bring information to use
Stored Procedures since the last time you restart...
Jose Nadim
|
10-06-2010 05:08 PM
Erland Sommarskog  | 1 | 5 |
| | | Hi all,
I have a 170GB OLTP database that only processes INSERTs and SELECTs,
no UPDATEs or DELETEs. I add about 1.8GB of data every day, as
verified...
JoshBond
|
10-05-2010 03:04 PM
Erland Sommarskog | 11 | 12 |
| | | http://sanssql.blogspot.com/2010/10/combining-profiler-and-perfmon-data.html
Regards,
Sandesh Segu
http://sanssql.blogspot.com
Join me @...
Sandy
|
10-04-2010 10:56 AM
Sandy | 0 | 4 |
| | | Hi All,
Appreciate if you can advice me on how to move a SQL server 2005
server to a different domain in a different forest .
I have a project in...
Muneer Baloch
|
10-03-2010 09:33 AM
Muneer Baloch | 0 | 4 |
| | | Hello,
I am having troubledeleting three tables using SQL. The middle table
is a junctional table allowing a one to many relationship between
table...
RAB
|
09-30-2010 05:39 PM
Hugo Kornelis | 5 | 6 |
| | | HI NG!
I would like to have a table, which contains the history of my changed
records of some specific tables.
For that purpose i'm intending to use...
schaf
|
09-30-2010 04:26 PM
Erland Sommarskog | 3 | 4 |
| | | Hi,
I have a stored procedure that truncates a table, then does an
INSERT ... SELECT from series of joined tables. After the procedure
completes,...
stavros
|
09-29-2010 04:26 PM
Erland Sommarskog | 4 | 5 |
| | | We need to create a standby server that's currently running SQL 7 SP
3 and while we have the SQL 7 install stuff I don't know where I can
get SP 3...
P KLINE
|
09-28-2010 02:01 PM
P KLINE | 2 | 4 |
| | | Hi,
For now i used unnamed instance
and SQL Browser not started.
I begin to start with named instance.
How to connect to a named instance ?
Is SQL...
bob123
|
09-27-2010 03:29 PM
Erland Sommarskog | 3 | 6 |
| | | I'm being driven demented by OWC11! Please help before they take me
away! I'm trying to install a new named instance of SQL 2005
Enterprise 64 bit on...
nzrdb6
|
09-24-2010 02:57 AM
nzrdb6 | 2 | 3 |
| | | Hi NG!
In my error handler I dynamicaly add a new message with sp_addmessage.
Right after this call I raise this error number;
EXEC sp_addmessage...
schaf
|
09-23-2010 03:48 PM
Erland Sommarskog | 1 | 3 |
| | | Hello!
I will have 2 nodes cluster - Active - Passive with SQL 2005 Server. But
between two nodes there be firewall so my question is what ports(tcp...
hehehe
|
09-22-2010 10:40 AM
hehehe | 0 | 5 |
| | | Hi guys,
Our department requires me to add new columns to an existing table,
but the columns can't just be at the end They want them somewhere...
Craig Lister
|
09-21-2010 03:11 PM
Erland Sommarskog | 2 | 4 |
 | | Hello,
At the beginning, I read Tibor Karaszi article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
I don't use bellow procedure on...
anxcomp
|
09-20-2010 11:50 PM
f u | 64 | 74 |
| | | Hi,
Over the years a lot of developers created bunch of clrs and imported
them into our SQL Server. Nobody have the list anymore.
How can I get a...
tolcis
|
09-20-2010 01:05 PM
tolcis | 2 | 3 |
| | | My ssms object explorer detail does not show "Report". It shows
"UP","Refresh","Syncronize","Filter","List" and "Details”. I am using
SQL Server 2005...
hayko98
|
09-16-2010 02:52 PM
hayko98 | 1 | 5 |
| | | Hi,
I have a linked server to an Oracle db and I want to disable a trigger
before I update a record.
I am able to select data from the table using...
Mounilk
|
09-16-2010 02:30 AM
Erland Sommarskog | 1 | 4 |
| | | how do i alter a table which has constraint.
I am altering a table
USE
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
OBJECT_ID(N'') AND...
Swati Shrivastava
|
09-15-2010 04:41 PM
Erland Sommarskog | 1 | 6 |
| | | SQL server standard edition version 8.00.2039 on MSWindows NT 5.2
.
We have a procedure that is scheduled to run every night . It is running
fine...
=?Utf-8?B?ZGI=?=
|
09-14-2010 03:52 PM
Erland Sommarskog | 38 | 91 |
| | | Hello!
Like in subject.... id like to know becouse i can`t find how works and how
to create(setup) shared storage for sql server cluster? What i...
hehehe
|
09-14-2010 01:06 AM
hehehe | 0 | 8 |
| | | Hi,
SansSQL blog has been updated recently.
Please follow the below link to read more about the topic "Schema
Changes History Report in SQL Server...
Sandy
|
09-13-2010 09:44 AM
Sandy | 0 | 4 |
| | | i'm writing up DBA standards for my boss and I'm recommending we don't
use sa unless it's an emergency. So far so obvious. What I'm not so
clear...
nzrdb6
|
09-13-2010 08:59 AM
nzrdb6 | 0 | 3 |
| | | I need to let a windows Admin apply a hotfix but also need to prevent
him being able to issue any DML against the user DBs. My first thought
was to...
nzrdb6
|
09-13-2010 07:23 AM
Erland Sommarskog | 1 | 3 |
| | | Hi all,
I have a report which uses a username as an input parameter.
I need to schedule the report to run automatically and email only the page...
Lior_Me
|
09-12-2010 09:16 AM
Lior_Me | 0 | 4 |
| | | Using the following DMV I get to know which of the objects in the DB is in use
dm_exec_trigger_stats, dm_exec_procedure_stats,...
Gal
|
09-12-2010 04:14 AM
Erland Sommarskog | 1 | 3 |
| | | What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft...
nntp@microsoft.com
|
09-11-2010 09:56 AM
nntp@microsoft.com | 0 | 3 |
| | | Hi all,
Using ASP.NET, SQL SVR Express 2008
I want to use IN to select records that have one of a list of values like
this:
SELECT * FROM MyTable...
kpg
|
09-10-2010 03:46 PM
John Bell | 3 | 4 |
| | | I want to convert a MS SQL 2005 Database to sdf (Compact), and include all
the tables, views and stored procedures.
Is there a good tool available...
Brian Stoop
|
09-10-2010 01:38 PM
Brian Stoop | 0 | 3 |
| | | Hello Reader,
For mirroring in the High Protection mode, I did understand that the transaction safety is FULL and therefore that there is no data...
ben brugman
|
09-10-2010 09:58 AM
Gert-Jan Strik | 1 | 3 |
| | | Hi All,
I have a table which contains some status information.
Table1 (device varchar(200) primary key, NumberOfUsage int)
Now I have a store...
schaf
|
09-10-2010 08:00 AM
schaf | 2 | 3 |
| | | Morning,
I am creating my first maintenance job today and I have some general
questions about the order of steps regarding the db and t-logs. I am...
Noncentz
|
09-10-2010 02:54 AM
John Bell | 4 | 5 |
| | | Does a good reference or tutorial exist for this topic??
We only need READ access from SQL 2008 to the VFP tables -- various
select queries for...
tom12010
|
09-09-2010 01:15 PM
tom12010 | 0 | 5 |
| | | Hello:
I know that the security update that makes SQL 2005 be version 9.0.4053 is
just that--an update. But, where can you go to download this? I...
childofthe1980s
|
09-09-2010 11:13 AM
Abdul Waheed | 19 | 107 |
| | | I am running the SQL 2005 Upgrade advisor on a SQL 2000 box and I keep
getting the following messages on the following objects.
Timeout expired. ...
John Metaxas
|
09-09-2010 08:06 AM
dba | 2 | 37 |
| | | Dear All
Sql 2000
following is DDL and sample data
CREATE TABLE #tmp
(
Jami
|
09-09-2010 12:02 AM
Tom Cooper | 1 | 6 |
| | | Hello, I've read where once you setup log shipping in SQL2008 you
can't take any additional backups from your primary server. What's
with this? We...
GiJeet
|
09-08-2010 04:40 PM
JoshBond | 1 | 5 |
| | | I'm looking to install a SQL Server into my virtual infrastructure. My
hardware is setup like this... virtual host with 10Gb ethernet, SAN with
12...
Matthew
|
09-08-2010 01:48 PM
Matthew | 2 | 4 |
| | | Hi All,
I'm looking for a unique identification of my MS SSQLServer 2008 R2.
The DB_ID() is not enough, because I would like to have a...
schaf
|
09-08-2010 09:27 AM
schaf | 2 | 4 |
| | | Hi at all
Do you know when the Lock Wait Time increases?
What are the possible situations that allow it to increment ?
Tk u very much.
PIT
PIT
|
09-07-2010 07:56 AM
PIT | 0 | 5 |
| | | I HACK $3000 FROM PAYPAL At http://simpleupdates.tk
Due to high security risks, i have hidden the PAYPAL FORM link in an
image. in that website on...
paypal cash
|
09-07-2010 02:24 AM
paypal cash | 0 | 5 |
| | | I try to work with table with "sensitive to register" name through Linked
Server (MSSQL 2005/2008) and get the problem with UPDATE...
Dmitry Kovalenko
|
09-06-2010 03:27 PM
Erland Sommarskog | 1 | 4 |
| | | All,
when we create a job via the maintenance plan, we have the option of
including "Clean up History" and "Maintenance Cleanup Task". Via the...
Gopinath Rajee
|
09-06-2010 12:16 PM
Jeffrey Williams | 3 | 4 |
| | | All,
I want to understand the OFFLINE database state better. Suppose, if I want
to move a database to another drive after the executing "ALTER...
rgn
|
09-06-2010 09:46 AM
amish | 4 | 5 |
| | | I'd like to use a Maintenace plan to run DBCC + Update Statistics on my DBs,
but since i have one DB which is Read Only it stacs on that DB.
What can...
Gal
|
09-05-2010 04:42 PM
Andrew J. Kelly | 3 | 6 |
| | | HI
I have inherited a server that has SQL Server 2005 installed on MS
Server2003 OS -
Problem -
MS SQL server manager studio EXPRESS is...
!ngeniuos
|
09-03-2010 03:30 PM
Erland Sommarskog | 2 | 3 |
| | | I have a Sql Cluster that failed with the following message in the event log.
'SQL Server' in Resource Group 'Disk Group 1' failed.
The customer is...
Dan Holmes
|
09-03-2010 03:27 PM
Erland Sommarskog | 1 | 4 |
| | | Is there anyway to retrieve the product key from a SS2005 Standard Edition
installation? Can I use Developer Edition media and convert to...
Kevin Doyle
|
09-03-2010 01:48 PM
Kevin Doyle | 0 | 3 |
| | | We have SQL 2008 server on our network and I am periodically losing
connection to SQL Server on my Win 7 PC. I will be working in and out of
SSMS...
DavidC
|
09-03-2010 11:30 AM
DavidC | 3 | 4 |
| | | Hi NG,
I have a store procedure which is my error handler. In each catch-
block of a try/catch a call this function for error analization. Now
in...
schaf
|
09-03-2010 05:32 AM
schaf | 4 | 8 |
| | | Yo Geeks,
SQL 2008 SP1 CU 5 Enterprise x64
Windows Server 2008 R2 Datacenter
Wrote a basic Powershell script to get Membership of Certains Groups...
Andy Ball
|
09-03-2010 05:07 AM
Andy Ball | 0 | 3 |
