pwalter83 (6/20/2014)

---

Sachin Nandanwar (6/20/2014)

---

I dont understand the problem here.Your query seems to be achieving it.

CREATE TABLE [dbo].[GL](

[Sequence] [int] NOT NULL,

[WK NO] [int] NULL,

[AC] [nvarchar](10) NULL,

[COMP] [nvarchar](10) NULL,

[USD_AMOUNT] [numeric](16, 2)...

Chord77 (6/20/2014)

---

That was my initial thought.

But then...

river1 (6/19/2014)

---

Hi,

I have this t-sql

CONVERT(VARCHAR(10),dt_inicio,105) >= CONVERT(VARCHAR(10),'01-01-2013',105)

the comparation is not correct because I'm comparing strings.

I would like to compare the day, month and year of the two dates.

How can...

You will have to use T-SQL to accomplish your task.

DBANoobie (6/18/2014)

---

Hello all-

I was told that if I wanted to setup mirroring between multiple instance on the same server that each endpoint had to be different number. Is that true?...

Be sure to check this out as well: http://ola.hallengren.com/.

Grant Fritchey (6/18/2014)

---

SQLRNNR (6/18/2014)

---

jasona.work (6/18/2014)

---

GilaMonster (6/17/2014)

---

Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

"No pressure to work overtime"...

I prefer NOT to use maintenance plans. Much more flexibility using procedures like Ola's (or home grown ones) to accomplish database maintenance processes.

The column base_object_name contains the <database>.<schema_name>.<object_name> of the synonym base object.

Look at this: http://msdn.microsoft.com/en-us/library/ms176105.aspx

As long as you are on the same server it should work. Here is some sample code to start with:

select

syn.name SynonymName,

...

Not much we can really do from here with the information provided. My suggestion is to get the actual execution plan from the queries involved and look at the...

Still slightly confused. Are you shrinking first then rebuilding indexes or the other way around?

And, why are you shrinking the database anyway?

Michael Valentine Jones (6/16/2014)

---

For about a week, the code tags feature has not been working for me in IE 10.0

It's fairly annoying to have to put in a code tag...

New Born DBA (6/16/2014)

---

I have this calculated field which shows the month of the report. Problem is that it only shows months from Jan, feb thru Dec. I am wondering...

First thing to understand is FILLFACTOR. Here is what it says under CREATE INDEX:

FILLFACTOR = fillfactor

Specifies a percentage that indicates how full the Database Engine should make the leaf...