ntrovato (6/10/2014)

---

Quite honestly, most of these decisions were already made before I started on this project ... so I'm pretty much stuck with this solution and I need to run...

ChrisM@Work (6/11/2014)

---

CREATE TABLE #temp (colint INT, colvarchar VARCHAR(10), colcomputed AS CAST(colvarchar AS INT))

INSERT INTO #temp (colint, colvarchar) SELECT 1, '10'

SELECT * FROM #temp

CREATE INDEX ix_colcomputed ON #temp (colcomputed)

SELECT colcomputed FROM...

kingrudedog (6/9/2014)

---

If the proper trusts are in place - are there any pitfalls to doing this?

Parent company wants us to use service account from their domain (without moving the server...

What do you get when you run sp_helpdb 'tempdb' ? Is this a Cluster?

SQL is delicious (6/10/2014)

---

sql-lover (6/9/2014)

---

thomaswoof (6/9/2014)

---

I'm having the exact same problem. The table had at some point been reseeded while importing data from the old version of the...

serge 83317 (5/17/2014)

---

We have two instances running in mirrored configuration. Two databases are being used by the same web application.

In the case a failover occurs on one of these databases,...

thomaswoof (6/9/2014)

---

I'm having the exact same problem. The table had at some point been reseeded while importing data from the old version of the software. So apparently...

vijay.singh 14112 (6/9/2014)

---

Hi Experts,

Can we upgrade SQL server 2000 DB's to Sql server 2012 directly? I tried restoring 2000 .bak in 2008 R2 but i am getting compatible errors. Should...

ramana3327 (6/9/2014)

---

Hi,

My requirement is before inserting new data, we need to delete the old data based on the input in 4 tables.

For this one I need to write 4 individual...

Here is mine ...

DECLARE @total int, @id int, @dbname varchar(200), @sql varchar(MAX)

DECLARE @t table(ID int not null identity(1,1), name varchar(255))

INSERT INTO @t(name)

SELECT name FROM sys.databases WHERE database_id >...

Jeff Moden (6/6/2014)

---

I've found that, especially in small to midsized...

sqldriver (6/6/2014)

---

sql-lover (6/6/2014)

---

It is my understanding that an aggregate function has to check all values in the column. So an Index on that attribute may not help too much.

Now, not...

The one that your supervisor does on you every year? To check if you are doing "Index Seeks" or just "scans" at your job? lol...

It is my understanding that an aggregate function has to check all values in the column. So an Index on that attribute may not help too much.

Now, not sure how...

sqldriver (6/5/2014)

---

hisakimatama (6/5/2014)

---

Yep, I've had that problem. Found NOLOCK all over the coding in the vendor-provided software at my current workplace my second day there, and reported it to...