Viewing 15 posts - 496 through 510 (of 521 total)
So you agree that they (nonrecursive CTEs) are no different than derived tables from a query processing perspective?
So when BOL states "Specifies a temporary named result set, known as a...
October 18, 2007 at 8:19 am
Hello Piotr,
Thanks for your response. If this is really the case that they can be thought of (loosely speaking) as temp tables, the following query plan doesn't fit into this...
October 18, 2007 at 1:12 am
You probably have null values in your name column in the BIG250MMTABLE table.
If you have NOT IN (x,y,NULL), then this will always evaluate to false.
Here is probably a better explanation:
October 17, 2007 at 2:15 pm
Even though I also agree that this should not be done in T-SQL, here is a method to wait for 5 seconds:
WAITFOR DELAY '00:00:05'
October 16, 2007 at 3:26 pm
Hello virgilash,
the first thing I would do is replace all LEFT JOINs with INNER JOINs.
Since you filter for ValidCurrency.Name in the WHERE clause there should be no outer rows.
October 16, 2007 at 2:39 pm
Do you already know which statements are running during the peak time? (from profiler)
October 16, 2007 at 1:50 pm
I am not sure if I understood this correctly, but are you looking for something like this?
SELECT REPLACE(object_definition(object_id(name)),'SERVERNAME','NEWSERVERNAME') FROM sys.objects WHERE type = 'P'
You could also replace the "CREATE" at...
October 15, 2007 at 10:18 am
Hello Andy,
you might want to try DDL triggers.
ALTER TRIGGER dTrgDenyDropTable ON DATABASE FOR DROP_TABLE
AS
SELECT EVENTDATA()
PRINT 'Not allowed!'
ROLLBACK;
GO
This is just a small sample to show you the basics. You can...
October 13, 2007 at 11:29 am
Hi rudy,
As mentioned before, QA is not the only application you can use.
One method to override your limitations is to use ADO, for example in a VBS.
Dim cn '...
October 12, 2007 at 12:23 am
EXEC sp_changedbowner 'newdbowner'
October 9, 2007 at 2:51 pm
Get rid of this call logging system. Quick.
QA is not the only method to issue queries agains the server.
Besides that, I dont see the necessity to ever use the Datareader...
October 9, 2007 at 2:39 pm
dmbaker (10/9/2007)
October 9, 2007 at 7:59 am
dmbaker (10/9/2007)
Why don't folks use structured storage files more, rather than storing packages in SQL Server?
Well one thing was already mentioned: You loose your package layout. While this is no...
October 9, 2007 at 7:27 am
Hello Owais Bashir Ahmed,
Thanks for this interesting Article!
I would like to add that you don't have to use the version ID when calling DTS Packages from within DTS Packages. Instead...
October 9, 2007 at 12:49 am
You might want to try this instead:
CREATE TABLE #space (name sysname, rows int, reserved varchar(50), data varchar(50), index_size varchar(50), unused varchar(50))
EXEC sp_MSforeachtable @command1='INSERT INTO #space EXEC sp_spaceused ''?'''
SELECT * FROM...
October 8, 2007 at 1:31 pm
Viewing 15 posts - 496 through 510 (of 521 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy