124 reputation
5
bio website theithobbit.blogspot.com
location United States
age
visits member for 2 years, 4 months
seen Sep 25 at 22:18

Independent Contractor, need a solution to a problem that is not a "Best Practices" problem, send me a message and we can discuss the opportunity

Favorite Online Tools:

Profiles:

Credentials:

  • IT Professional (1995 - Present)
  • Desktop Support (1995 - Present)
  • Client/Server Development (2006 - Present)
  • Web Development (2001 - Present)
  • Sys Admin (2008 - Present)
  • DBA (2006 - Present)
  • VBA (1994 - 1999, 2011 - Present)

Sep
24
awarded  Autobiographer
Apr
29
awarded  Supporter
Apr
29
comment Test if any fields are NULL
+1 This worked wonders. Only had 1.1k rows to check for. FYI this also evaluates the textual version of NULL.
Sep
12
comment Does Reporting Services lock tables?
@Shark but to not consider the Default settings when designing a query would be adding more resources that are unnecessary to your transactions. Just making sure you understand that the Implicit (Default) settings can carry weight into how your server processes transactions and what locking mechanisms are/not set per transaction. So to think of it as Explicit or Implicit is very important when it comes to Snapshot isolation. Seeing the forest vs the Tree.
Sep
12
awarded  Scholar
Sep
12
accepted VARCHAR NULL storage
Sep
12
awarded  Commentator
Sep
12
comment Does Reporting Services lock tables?
@DiegoJancic nod....Snapshot isnt technically new, since Access has been using it (in various forms) since 2000/2003'ish. MS SQL's earliest implementation was really in 2005, even though 2000 has a ghost of an implementation (which was nasty). Database Snapshots were fully implemented in 2008 with a more efficient form of Leaf Locks in 2008r2. In my experience, if you wanted a lock you explicitly design the query with the syntax, otherwise leave the Locking mechanism open by default.
Sep
12
comment Does Reporting Services lock tables?
@CleanFill experience in supporting those environments. You notice a bigger hit when your Service CPU Utilization hits around 75-80% utilization.
Sep
12
comment Does Reporting Services lock tables?
@Shark Really then why are Batches only committed at the end, and not while it is happening? If everything wasnt a SnapShot Isolation then you wouldnt need to Commit them at all. Read Committed is a subset of SnapShot Isolation. By definition a Snapshot is a view of data at the time of the query.
Sep
12
comment Does Reporting Services lock tables?
@DiegoJancic RS, if you mean RecordSets, are not TSQL. Even though the Query results in a TSQL, they are two different view points pending on which end of the transaction your talking about.
Sep
12
comment SQL server moved, now can't use as linked server
let us continue this discussion in chat
Sep
12
comment SQL server moved, now can't use as linked server
Linked server is at the server level, not SSMS. SSMS will do various searches using means not available to the SQL Server. SSMS is a client application that will use LDAP, AD and other Connection authentication means. SQL Server only uses OLE DB connectivity for Linked Servers. check this thread out
Sep
12
comment SQL server moved, now can't use as linked server
Another problem you are going to have, is the outdated connection properties of 2000. If they updated to SQL-2012/13, you may have a problem with connectivity from 2000. As 2000 is more than 2 version behind, Microsoft is notorious for deprecating alot of functionality in a connection library within 2 version.
Sep
12
comment SQL server moved, now can't use as linked server
It can be, it can be associated with the AD-Group they are members of, the Credential Group, or the Account used to login to the Server. Pending on how they setup the account your using pends on which UserLogin tree they edit.
Sep
12
comment SQL server moved, now can't use as linked server
In 2005, you could manage the rights of a UserLogin/Credential to specific server(s)/Database/Schema. As such, if they moved the server, the address changed (IP[4/6], HostName, Instance) and did not make the appropriate change to the UserLogin/Credential then your going to dead space. Which is what you are doing now, being pointed to a dead-end street.
Sep
12
answered Does Reporting Services lock tables?
Sep
12
answered SQL server moved, now can't use as linked server
Jul
15
comment VARCHAR NULL storage
I knew it was new to 2008(r2) but couldnt remember the keyword for the new attribute for varchar data type.
Jul
13
awarded  Student