Viewing 15 posts - 42,046 through 42,060 (of 49,571 total)
Jeff Moden (1/1/2009)
This is obviously either homework or an interview test.
And it doesn't appear to be particularly urgent.
January 1, 2009 at 2:13 pm
As I asked before, have you read through the sections in Books Online on the encryption hierarchy and how the encryption works?
A very quick google search on EncryptByPassphrase turned these...
January 1, 2009 at 1:50 pm
ALZDBA (1/1/2009)
first read: http://www.sommarskog.se/dynamic_sql.htmlThen : this is certainly not a best practice !
In addition, make sure you know what SQL injection is and how to prevent it.
January 1, 2009 at 1:45 pm
Just make sure that you have the correct data types in your source table, ie dates are stored as datetimes and the numbers are stored as numeric, decimal or money,...
January 1, 2009 at 12:14 pm
WayneS (1/1/2009)
Just prior to the full backup, we run a "backup log with no_log", followed by a "dbcc shrinkfile" on the database log file to shrink it to 50mb.
Why? If...
January 1, 2009 at 11:32 am
Mark (1/1/2009)
The problem I have with his solution is that he has a predefined set. No one has a predefined set of data in the real world.
That's...
January 1, 2009 at 11:31 am
I'll check the exec plan when I get SQL reinstalled. In the meantime, what's the definition of fnGetTerrTree, and can you post the schemas of the tables (as create table...
January 1, 2009 at 11:24 am
Please post table structure (as create table statements), some sample data and your expected results. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Do you...
January 1, 2009 at 5:57 am
What are the queries associated?
DBID 32757 is the resource database, where all the system views, functions and procedures are stored. So if the queries that you see are system procs,...
January 1, 2009 at 5:38 am
The tran log's not encrypted, but it's not designed to be human-readable. As far as I know, there are no official documents that are publicly released describing the data in...
January 1, 2009 at 5:35 am
RBarryYoung (12/31/2008)
The irony of course is that if SUM(..) OVER(..) allowed ORDER BY, 2/3rds of the uses for it (the Update pseudo-cursor) would disappear.
Apparently (and this is not confirmed), that's...
January 1, 2009 at 5:15 am
homebrew01 (12/31/2008)
December 31, 2008 at 8:27 am
bhimrajg (12/31/2008)
Ok....Here is simple query :
Is that the select inside one of the udfs?
What about the other udf?
And Please check the execution plan
Right click the exec plan, select save...
December 31, 2008 at 8:20 am
Perry Whittle (12/31/2008)
December 31, 2008 at 8:08 am
bhimrajg (12/31/2008)
I have uploded the execution plan below
You can zip it and attach it to your post here.
December 31, 2008 at 8:01 am
Viewing 15 posts - 42,046 through 42,060 (of 49,571 total)