If the first part of the question question is: "What static data...

Well... if you have the tables that means that you already have a...

bijarcity (1/2/2012)

---

hi thank you so much for your paying attention.

i have 2 computers and i installed sql server on them.i have a same data in the two sqlservers.

i have a...

ychen1214 (12/31/2011)

---

I have been a SQL developer for about 4 1/2 years now. For the past couple of months, I haven't really improve my SQL skills. I have been trying...

How about differential backups? if the issue is space the size of differential backups will follow the volume of data that actually changed on those particular databases.

For these low...

How to: Check the ODBC SQL Server Driver Version (Windows)

SQL Server 2008 R2

Your computer may contain a variety of ODBC drivers, from Microsoft and from other companies. Use the Windows...

Yes, I think so - what do you think?

Why don't you start by showing us your ER model?

Dev (12/30/2011)

---

PaulB-TheOneAndOnly (12/30/2011)

---

jr.sqldba (12/30/2011)

---

Hi,

I have created database and enter the values in to that table.

and also perform the explicit transaction after that in another window i wrote the...

WangcChiKaBastar (12/30/2011)

---

SQL queries/calls are running terribly slow from .Net Application

but when we run the same query on SSMS its fine.

I ran profiler but didnt get much clue, Tlog is OK...

Adding on Perry's comment.

Is this a plain "migration" as in hardware refresh, no SQL...

jr.sqldba (12/30/2011)

---

Hi,

I have created database and enter the values in to that table.

and also perform the explicit transaction after that in another window i wrote the below steps

SHUTDOWN WITH NOWAIT;

GO

but...

Gianluca Sartori (12/30/2011)

---

PaulB-TheOneAndOnly (12/29/2011)

---

How about using coalesce?

create table #test(id decimal);

insert into #test values(1);

insert into #test values(2);

insert into #test values(3);

insert into #test values(4);

insert into #test values(5);

insert into...

how about replacing:

over (partition by account_number order by end_date asc )

by:

top 1 over (partition by account_number order by end_date desc)

I remember having to do it a few years ago.

Didn't use a third party tool but a set of three stored procedures: sp_hexadecimal, sp_help_revlogin and a sligthly hacked version of...

David Moutray (12/29/2011)

---

Ah, yes, I am responsible for performance, and that is just my frustration. These so-called developers are allowed to implement code which "works" on their test system...