Eugene Elutin

Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 2,894 total)

RE: DBCC

Always trying my best! 😀
Actually I have a version of compiled machine code for this. It goes something like:
010001011110100101110111100001110001101110110101011011101001
010101011101101010101110110011101110111101111011110111111011
110110110111101111011000110110101101110111110111011010111011
etc. (It actually few thousand pages, but I can attach the...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 6:31 am

#1478072
RE: DBCC

Call Microsoft and ask them to send you copy of SQL Server source code. Be nice with them and I'm sure they will help you... :hehe:
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 6:15 am

#1478063
RE: Linked Server - OpenQuery - Stored Procedure with insert Statement

Can you post ddl for your procedure
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 6:12 am

#1478061
RE: sql 2k >> sql 2k8: text, ntext and image

Nothing!
But it is recommended to use varchar(max), nvarchar(max) and varbinary(max) instead.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 5:30 am

#1478036
RE: Filtering rows from one table.

You have placed '2012-04-29 08:30:00','SOME TEXT' into your expected results, but it is present in #tableTwo?
What it makes to be picked up for the result?
Is it just because...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 5:26 am

#1478032
RE: Disk space when varchar to nvarchar change

khushbu (4/24/2012)
Eugene Elutin (4/24/2012)
khushbu (4/24/2012)
Yea.. i know
nvarchar = 2(varchar)+2
where +2 coming from?
From BOL: http://msdn.microsoft.com/en-us/library/ms186939.aspx
nvarchar [ ( n | max ) ]
Variable-length Unicode string data. n defines the...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 4:28 am

#1478010
RE: Disk space when varchar to nvarchar change

khushbu (4/24/2012)
Yea.. i know
nvarchar = 2(varchar)+2
where +2 coming from?
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 4:03 am

#1477998
RE: Disk space when varchar to nvarchar change

Yeah, but you can simply multiply varchar column sizes by two, as it will give you much larger number than it will really take.
Saying that current column varchar(100), changing it...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 3:39 am

#1477991
RE: Need to gather the source process for a SQL server query

Are you looking for Auditing solution?
Depends on the depth of details you want to trace, there are few methods and most common are:
- custom auditing using light-weight audit triggers (still...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 3:31 am

#1477987
RE: Column = anything

Is there any way to code "WHERE column = anything" without using dynamic sql?
Yes it is possible:
SELECT * FROM Table WHERE Column = Column OR Column IS NULL
I'm sure you...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 2:31 am

#1477966
RE: how to join 2 temp table into 1

I love threads from this OP, they make my day!
They are example of horror, drama and comedy in one!
a la Alfred Hitchcock
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 2:20 am

#1477962
RE: Handling Multiple transaction

You most likely do not need to use loop.
Please follow the link at the bottom of my signature to find out what we need to help you.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 24, 2012 at 2:16 am

#1477959
RE: How to change the SQL query editor color for different server connections.

Go low-tech:
Use three PC's or non-permanent marker.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 23, 2012 at 6:44 am

#1477453
RE: Is Cursor Really Not Good?

Charmer (4/23/2012)
Eugene Elutin (4/23/2012)
Cursors are not Really Good or Really Bad!
They designed and should be used for relevant tasks.
However your example is not one of them...
My cursor is taking...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 23, 2012 at 6:41 am

#1477451
RE: Messages Tab (Query)

maryamzolfaghar (4/23/2012)
sqlcmd -S servername\instanceName -i inputfile -o outputfile
inputfile contains the sql query
outputfile: The output goes here, but the results tab output and messages pad are both included
I need the...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

April 23, 2012 at 6:38 am

#1477447

Viewing 15 posts - 1,711 through 1,725 (of 2,894 total)