RE: QueryTool complaint
Can't you just provide these "spoiled end-users" with customized views ?!?! Why spoil them any more than they already are ?!ps:prefer strawberries and cream myself!
2005-05-16
DAX
Domain Login without domain prefix
Is it possible to have a domain login to RS with out having to have the domain prefix. I know this can be done with a local login but I want to manage everyone with AD. It gets old having to explain to everyone that they have to type domainblah\username TIA for any replies!
2005-05-16
125 reads
Indexed Views With Outer Joins
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/jBulinckx/indexedviewswithouterjoins.asp
2005-05-04
66 reads
RE: What should be the daily routine of a ideal DBA
Hey Aaron, how many of the forums did you post this on? Is this part of your daily routine?
2005-04-05
SQL Server and VPN
I have a SQL server in 192.168.168.100. Our network has both VPN and Firewall.My goal is to setup our Firewall so only the inside computers can access the SQL server. But all the outside computers can not access the Server. The inside computers mean the computers that connect to the network directly. The outside computers mean the […]
2005-04-05
RE: Insert on Linked Server
Read the BOL section titled "BEGIN DISTRIBUTED TRANSACTION"And also the section titled "SET REMOTE_PROC_TRANSACTIONS"
2005-03-14
RE: How to get available memory using SQL
It's not a table : run this in the master table Select objectproperty(object_id('sysperfinfo'), 'TableIsFake') It will return 1. This means than when you query that table, Sql server meterializes it so that the query can execute, but this information is never actually kept on the hd like a real table. checks BOLS : objectproperty::TableIsFake
2005-03-02
RE: DTSRun: Cannot create COM Server to load and execute DTS Package
my dtsrun utility was simply corrupt. I just ran it on a different server fine, with no problem. The dll entry point was the problem on this machineviolla
2005-02-21
RE: database icon say (Loading)
Or did you restore with norecovery option? Check SQL Server errorlog, If you see message "Bypassing recovery for database 'xxx' because it is marked IN LOAD", Try restore the database recovery option.
2004-11-23
RE: Compacting DB
Hey,Are you familiar with SQL DMO Libraries ? you can do all the actions of SQL EM using sqldmo libraries. i dont have any code base for the same. just have a look at this COM and if you are facing any probs let me know.Jeswanth
2004-11-17
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers