Viewing 15 posts - 2,416 through 2,430 (of 8,731 total)
I've only been to 2 SQL Saturdays.
For the first one I had to travel 130 miles (209km) to Orlando on 2012. We went to Disney World on Sunday, so we...
July 29, 2016 at 8:33 am
TomThomson (7/28/2016)
jasona.work (7/27/2016)
Luis Cazares (7/27/2016)
July 29, 2016 at 7:31 am
Why does record_id 2 ends up with value 'col1' for colname?
Have you tried using MAX() and MIN() to aggregate rows?
July 28, 2016 at 1:36 pm
This is interesting. I'm not sure if that's a bug or a feature. I would be inclined to call it a bug.
July 28, 2016 at 8:12 am
Douglas Rosa (7/27/2016)
Tambien quisiera consultarles como podria montar o generar un informe el cual me diera el estado de salud de una instancia de sql server.
Una de las formas más...
July 27, 2016 at 10:59 am
It's exhausting to write translated posts. I hope I'm not saying any nonsense as I'm a bit outside my common knowledge (referring to DBA tasks, not Spanish :-D).
July 27, 2016 at 9:41 am
Douglas Rosa
July 27, 2016 at 9:36 am
This is another option:
SELECTAPPLICANTS_ID,
APPL_CURRENT_STATUS,
APPL_CURRENT_STATUS_DATE
FROM APPLICANTS
OUTER APPLY( SELECT TOP 1 *
...
July 27, 2016 at 7:38 am
This is one option:
WITH CTE AS(
SELECTAPPLICANTS_ID,
APPLICATIONS_OCC.APPL_CURRENT_STATUS,
APPL_CURRENT_STATUS_DATE
...
July 27, 2016 at 7:35 am
The most important part. How do you define the file has junk data?
July 27, 2016 at 7:32 am
Or you could use a table with all possible values.
Here's an example on how to create it.
CREATE TABLE Weeks(
WeekCode int,
...
July 27, 2016 at 7:28 am
¿Por qué quieres poner una limitación al diseño de la base de datos? El tener distintos filegroups y archivos te permitirá tener un diseño físico más flexible y puede facilitar...
July 27, 2016 at 6:24 am
GilaMonster (7/27/2016)
Can someone who speaks Spanish please check the translations? http://www.sqlservercentral.com/Forums/Topic1804719-2799-1.aspx
Your response is translated correctly. I was going to reply but I haven't reached my computer yet.
July 27, 2016 at 5:30 am
Or you could try SQL Search (free product): http://www.red-gate.com/products/sql-development/sql-search/
July 26, 2016 at 12:14 pm
Viewing 15 posts - 2,416 through 2,430 (of 8,731 total)