CELKO (2/24/2015)

---

...

You should follow ISO-8601 rules for displaying temporal data. This is the second most used ISO standard on Earth (the metric system is #1) and you do not know...

RamSteve (2/24/2015)

---

So will there be any issues in using with(NOLOCK) for sys schemas ? I had the habit of using every where in SQL Statements ..What would be the pros...

RamSteve (2/24/2015)

---

Hi,

I have the following 2 Query's - case when Table has no Identity Column and other with identity Column . I am planning to make it to single...

Good work! appreciate it.

😎

It popped up on "Recent Posts" two days ago, thought it was funny:-D

😎

KGJ-Dev (2/23/2015)

---

Hi Erik,

Here is my confusion, if i use the Sean's suggestion i am in the position to use the same query for two times as i need that output...

Quick suggestion, use the sys.sql_expression_dependencies system view

😎

SELECT

SD.*

FROM sys.sql_expression_dependencies SD

WHERE SD.referenced_database_name IS NOT NULL

;

Duplicate post, answer on this thread

😎

Quick solution using FOR XML PATH and a nested query

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.Candidates') IS NOT NULL DROP TABLE dbo.Candidates;

create table dbo.Candidates(eno int,ResumeText varchar(30), Email varchar(30),Active varchar(30),postalcode varchar(30),country int)

;

insert into...

Go with Sean's method, no need to "materialize" the set and better chances of benefiting from the cache.

😎

You have a Windows 2000 Advanced Edition Server...

....and you have a serious problem:blush:

😎

PS this question looks to me like a Y2000 bug:-D

shreekanth.kavali (2/22/2015)

---

you received an alert "disk drive is almost full " for c drive "abc" server .what action will take and what all information you will provide for further action...

sk88 (2/22/2015)

---

Thank you so much. However, the declare function is giving me an error message

ORA-06550: line 1, column 9:

PLS-00103: Encountered the symbol "@" when expecting one of the following:

...

Further on Grant's, post the full and unedited output of "DBCC CHECKDB(‘DatabaseName’) WITH NO_INFOMSGS, ALL_ERRORMSGS"

😎

Quick note, this seemingly simple task may be slightly more complex than it appears to be at first. 😉 , i.e. in your data sample there are no updates to...