Nagaram (6/13/2012)

---

I am not sure on which rank function needs to be apply and where to apply to get above RANK .

In my sample data TECH_MODE field have value...

Nagaram (6/13/2012)

---

Actually I need to apply one of the rank function .

Expected output 1:

IDREFERENCE_IDTECH_MODE_IDBEGIN_TIMEEND_TIME RANK

1162012-05-03 20:29:22.0002012-05-03...

440692 I am just a number (6/13/2012)

---

SET DATEFORMAT dmy;

GO

SELECT

[Getdate] = GETDATE()

,[Year] = DATEPART ( yy , GETDATE() )

,[Month] = DATEPART ( mm , GETDATE() )

,[Day] = DATEPART ( dd...

ChrisM@Work (6/13/2012)

---

AndrewSQLDBA (6/13/2012)

---

HI Everyone

I have something simple that I am getting stumped on.

I have a complete date with time (2012-06-12 10:43:37), and I need only the date portion. I...

Check that the SQL Server Express is configured to accept remote connections.

glamourth (6/13/2012)

---

Hi All,

I have used sys.dm_exec_query_stats and sys.sysprocesses to find long running queries particulary more than 60 minutes. But, as am not gud at sql scripting not able to join...

Absolutely no idea. Are there any other error messages in the sql error logs?

What is missing from the description of your problem is the error message you are getting while trying to connect to the instance of SQL Server Express. Without all...

isuckatsql (6/12/2012)

---

I removed the ‘GUID’ field and used an ‘INT’ ID field instead for the primary key and clustered indexes, and got the query down to:

SQL Server Execution Times:

...

I love it (sic):

OP: I have a problem.

Forum: What?

OP: SQL Server is only using 60 GB of memory and I have max memory set at 100 GB.

Forum: Aaarrrrrgggghhhhhhhhhh!...

Not a problem. SQL Server is able to meet your users needs with only 60 GB of memory. If it needs more, it will take it and use...

h_maksuda (6/12/2012)

---

Hi,

I have a table with the following data structure-

IDF1F2F3

11nullnull

1null1null

1nullnull1

I want to get the result in the following way -

IDF1F2F3

1111

how can I write the Query?

Any kind of help is appreciated.

Thanks...

sonia.burns (6/12/2012)

---

No further forward, On my test server I installed two instances of SQL server and repeated my previous mirroring steps, using the same ports and the same domain admin...

I have a suggestion, post the DDL for the tables involved, some sample data (something that without restrictions would return say 10 to 12 rows of data), the expected results...

shil_jsh (6/12/2012)

---

Hi,

I've two tables in the production does not have the primary key and foreign keys and yet I've to join those two tables in order to get the data...